I have a table set up like this
(this is what is relevent, anyway)
OrderNumber | ItemNumber|UserID|TransactionStatus
102 356 98 0
102 357 98 0
103 358 52 0
104 359 100 0
Maybe this will give a better picture.
For each order number I want to print the item number and user id with it, but I only need to print to order number 1 time.
Here is my query
$order = mysql_query("SELECT * FROM $table WHERE TransactionStatus = '0'");
When I use this I am getting all of the order numbers and putting them into an array.
So I have, in this case 102 twice.
Is there a way I can format my query to only get a value once OR is there a way to look through the array and get rid of double values? I tried doing the last one, but it wasn't working properly. I would appreciate any suggestions!
