Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Dynamic Dropdowns › Pointer in the right direction required

Pointer in the right direction required

Thread began 9/11/2009 6:30 am by John Langer | Last modified 9/14/2009 12:02 pm by John Langer | 3175 views | 6 replies

9/14/2009 12:02 pmJohn LangerBeta Tester

Solved

Steven Seiller over at CMX solved this for me. Seems you need a sub-select

SELECT bbc_people.id, bbc_people.firstname, bbc_people.lastname, bbc_people.realmail
FROM bbc_people
WHERE bbc_people.id NOT IN (SELECT bbc_listmembers.person_id FROM bbc_listmembers WHERE bbc_listmembers.list_id = MMColParam)
ORDER BY lastname ASC

MMColParam = $row_bbc_listmembers['list_id']

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.