DISTINCT & GROUP BY on the same query.

I'm going crazy with this. Please help!!!

Right now I have the following query:

SELECT name, COUNT(name), time, price, ip, SUM(price) FROM tablename WHERE time >= $yesterday AND time <$today GROUP BY name

PHP:

And what I'd like to do is add a DISTINCT by column 'ip', i.e.

SELECT DISTINCT ip FROM tablename 

PHP:

So my final output would be all the columns, from all the rows that where time is today, grouped by name (with name count for each repeating name) and no duplicate ip addresses.

What should my query look like? (or alternatively, how can I add the missing filter to the output with php)?

Thanks in advance.

 

Ummm.. Maybe you just need to add this to the end of your query and see if the result is what you need:
, ip

 

how about it?

SELECT name, COUNT(name), time, price, ip, SUM(price) FROM tablename WHERE time >= $yesterday AND time <$today GROUP BY name, ip

PHP:

 

Do this first

$sql = "SELECT DISTINCT ip FROM tablename";
$query = mysql_query($sql);
while (list($ip) = mysql_fetch_array($query))
{
    //collect rest of the data
}

Code (markup):

Then run your other query to get the rest of the data, using the ip as your identifier.