Jump to content

Archived

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

tobestar

Missing Results returned in SQL??

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:

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

:o

 

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.

Share this post


Link to post
Share on other sites

×

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.