> >
> $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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
