tobestar

I have discovered that the problem was a line in my PHP code. Thank you very much for your reply anyway. Have a great xmas.

I am having the most bizarre situation when I am trying to use DISTINCT or GROUP BY in a SQL query. I have several suburbs in my table. Some of them repeat, and I am trying to display them in a list box. No problem... I use $result= MYSQL_QUERY(\"SELECT * FROM renovator); and I get everything I need, but of course there are repeated values. so... $result= MYSQL_QUERY(\"SELECT DISTINCT suburb FROM renovator WHERE region = \'$region\' ORDER BY suburb ASC\"); great... works a treat, but there is a value(suburb) missing. No matter what I do, I cannot get all the values to show up. AND... $result= MYSQL_QUERY(\"SELECT DISTINCT suburb FROM renovator WHERE region = \'$region\'\"); returns a different set of values... with the suburb I needed present, but now a different suburb missing?? I have no idea what is going on. PLEASE HELP!!!