RE: [PHP] Going a bit nuts with php/mysql structure......(maybe 0T)
| From: | Chris W. Parker | Date: | Wed, 18 Feb 2004 21:19:12 +0000 |
| Subject: | RE: [PHP] Going a bit nuts with php/mysql structure......(maybe 0T) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-178174@lists.php.net to get a copy of this message | ||
Ryan A <mailto:ryan@coinpass.com>
on Wednesday, February 18, 2004 12:18 PM said:
> I have the 3 distinct order_ids, but when I try to do a "select
> *....where order_id='$order_ids' " on the order_ids...I get all the
> damn records. The only thing truly unique is the CNO....but I have
> been unable to get a "cno,disctinct(order_id)" as that kicks up
> a mysql error.... WHAT TO DO???
i think you want GROUP BY and not DISTINCT.
http://www.w3schools.com/sql/sql_groupby.asp
chris.