RE: Newbie DISTINCT problem

2001-03-17 Thread Don Read
On 18-Mar-01 Tom Beidler wrote: > 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 hav

Newbie DISTINCT problem

2001-03-17 Thread Tom Beidler
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 WHER