Ryan A <mailto:[EMAIL PROTECTED]> 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. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
