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? Link to comment https://forums.phpfreaks.com/topic/17349-one-result-per-series-please-help/ 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 Link to comment https://forums.phpfreaks.com/topic/17349-one-result-per-series-please-help/#findComment-73775 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] Link to comment https://forums.phpfreaks.com/topic/17349-one-result-per-series-please-help/#findComment-74810 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.