Jump to content

Archived

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

Cloud9247

One Result Per Series? Please HELP

Recommended Posts

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?

Share this post


Link to post
Share on other sites
use SELECT DISTINCT series as part of your query

Share this post


Link to post
Share on other sites
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]

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.