tobestar Posted December 17, 2003 Share Posted December 17, 2003 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!!! Quote Link to comment https://forums.phpfreaks.com/topic/1516-missing-results-returned-in-sql/ Share on other sites More sharing options...
Barand Posted December 17, 2003 Share Posted December 17, 2003 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 Quote Link to comment https://forums.phpfreaks.com/topic/1516-missing-results-returned-in-sql/#findComment-4989 Share on other sites More sharing options...
tobestar Posted December 17, 2003 Author Share Posted December 17, 2003 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. Quote Link to comment https://forums.phpfreaks.com/topic/1516-missing-results-returned-in-sql/#findComment-4998 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.