Jump to content

Missing Results returned in SQL??


tobestar

Recommended Posts

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!!! :cry:

Link to comment
https://forums.phpfreaks.com/topic/1516-missing-results-returned-in-sql/
Share on other sites

Your SQL looks OK so I would look at the data, prticularly spellings of \'region\' (if it\'s alpha) or extra space char at end of one maybe.

 

Try

\"SELECT DISTINCT region, suburb FROM renovator ORDER BY region, suburb\"

and see if that throws up any clues.

 

hth

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.