Hi, Like I said before am working on a project that someone else created so dont blame me for this daft architecture.
The problem is in the products table, he has the name and products in one table, this is the structure and records: cno order_id name product 1 234455 ryan 123 2 234455 ryan 345 3 234455 ryan 111 4 545544 susan 111 5 545544 susan 121 6 447474 jack 111 I have to paginate the results and only display one record per name in the clients "control panel", I am first running a DISTINCT(order_id), getting the mysql_num_rows() and setting the paginating class properly, so far so good. 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??? If you want the code, tell me and i'll mail it to you offlist. Thanks, -Ryan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
