We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

how can i get all Gallery album names in a listbox TV?

    • 24629
    • 370 Posts
    Ralph Zelf Reply #1, 15 years, 8 months ago
    Hi Guys,

    i want a listbox TV in a template. Now i want to list all Gallery albums that have been created with the Gallery component in that listbox.
    How can i call those in the Input Option Values ?
    i tried thi allready but no go
    @SELECT * AS `name`,`id` FROM `[[+PREFIX]]gallery`


    anyone?

    tnx Ralph
      • 4172
      • 5,888 Posts
      Bruno17 Reply #2, 15 years, 8 months ago
      try
      @SELECT `name`,`id` FROM `[[+PREFIX]]gallery_albums`
        -------------------------------

        you can buy me a beer, if you like MIGX

        http://webcmsolutions.de/migx.html

        Thanks!
        • 24629
        • 370 Posts
        Ralph Zelf Reply #3, 15 years, 8 months ago
        HI Bruno,

        thanks it worked,
        I can’t believe i was that close;)

        Ralph