Cloud9247 Posted August 12, 2006 Share Posted August 12, 2006 currrently I am retrieving data from a database named 'graphics', I want it to list all the series in ther database, but I don't want it to repeat the same series twice. How do I make it so a series' name doesn't show more than once? Quote Link to comment Share on other sites More sharing options...
AndyB Posted August 12, 2006 Share Posted August 12, 2006 use SELECT DISTINCT series as part of your query Quote Link to comment Share on other sites More sharing options...
Cloud9247 Posted August 14, 2006 Author Share Posted August 14, 2006 I u7sed that, but it still is repeating the same series twice, why? this is my query:[code] $sqll= "SELECT DISTINCT id, active, series FROM graphics WHERE active='1' ORDER BY `series` ASC";$rss= mysql_query( $sqll, $connection );while($row= mysql_fetch_array( $rss )) {[/code] Quote Link to comment 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.