$result=mysql_query("SELECT distinct(order_id),name,status,total FROM
".
$tcname."_h2o LIMIT $limit1, $limit2");
The distinct keyword applies to the whole row. Since you're including other fields that will be different even though the name is the same, MySQL does not consider them duplicate rows.
-- Stuart
Hey Stuart, Thanks for replying.
So what can I do to make sure I get only order_id distinct? possible?
Thanks, -Ryan
SELECT DISTINCT order_id FROM ...
Then loop through the results and run another query to find out details of each order.
HTH,
Mike
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php