I'm trying to populate a pulldown menu with distinct values from a found set
using the following query.
SELECT DISTINCT name FROM request
WHERE id <= '5' OR demo_id = '$demo_id'
ORDER BY name
Apparently I am doing something wrong. If I have a record with the same name
that meets the WHERE parameters and one that doesn't, the name won't appear
in my pulldown menu.
What am I doing wrong?
Thanks,
Tom
>>.>>.>>>.>>>>>.>>>>>>>>>.>>>>>>>>
Tom Beidler
Orbit Tech Services
805.682.8972 (phone)
805.682.5833 (fax)
[EMAIL PROTECTED]
http://www.orbittechservices.com/
>>.>>.>>>.>>>>>.>>>>>>>>>.>>>>>>>>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
