Re: Crappy results from query
| From: | Stuart | Date: | Wed, 18 Feb 2004 14:32:01 +0000 |
| Subject: | Re: Crappy results from query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-178106@lists.php.net to get a copy of this message | ||
Ryan A wrote:
$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