On Mon, October 9, 2006 3:09 pm, afan@xxxxxxxx wrote: > But, in this case I will have repeating order_date and order_status > info? > > id order_date status file_name > 12 2006-10-09 live file1.jpg > 12 2006-10-09 live file2.jpg > 12 2006-10-09 live file3.jpg > 13 2006-10-09 live file1.jpg > 14 2006-10-09 live test.gif Yes. But what you print out and what you have in each result row need not be exactly one-to-one. $last_order_id = ''; while (... mysql_fetch_row($result)){ if ($last_order_id != $order_id){ echo "$order_id $order_date $status<br />\n"; $last_order_id = $order_id; } echo " $file_name<br />\n"; } Here we only print out the order_id etc when the order_id changes, not for every uploaded file. -- Some people have a "gift" link here. Know what I want? I want you to buy a CD from some starving artist. http://cdbaby.com/browse/from/lynch Yeah, I get a buck. So? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php