We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 10780
    • 69 Posts
    I am trying to populate a drop down menu from another section of my site.

    @SELECT pagetitle FROM schemes WHERE parent=’3’

    That’s what I added but when I then go into the resource it just gives me a blank page.

    Where am I going wrong? Still new at Modx so it’s taking me longer to get to grips with things.
      • 4310
      • 2,310 Posts
      @SELECT pagetitle,pagetitle FROM schemes WHERE parent='3'

      You need two fields, the first is the Manager display value, the second the stored value.
        • 10780
        • 69 Posts
        Still not working.

        Can you break it down for me?

        Where I have ’schemes’ that is the Resource Parent right?
          • 4310
          • 2,310 Posts
          I assumed ’schemes’ was a custom table in your MODx database, if not then it should be your site content table, probably :
          @SELECT pagetitle,pagetitle FROM modx_site_content WHERE parent='3'
            • 10780
            • 69 Posts
            Ah right. I was looking at that wrong.

            Thanks. Works now.
              • 10780
              • 69 Posts
              Just one more thing? Am I able to add another value to the drop down, and call it something like General, or Other?