Yes you are right, but I guess you can decide which is worse: sending extra data in one query or send extra queries. I guess it depends on how many records we're talking about... Brad also brings up a good point I hadn't considered. I do think an OUTER join is possible, perhaps depending on your mysql version... Which brings up something I had meant to say before, which is that this isn't actually a PHP question... :) John W On 10/9/06, afan@xxxxxxxx <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 right? > On 10/9/06, afan@xxxxxxxx <afan@xxxxxxxx> wrote: >> but I know there must be much better solution then this one. > > You're right: Simply JOIN your queries... > > SELECT order_id, order_date, order_status, file_name > FROM orders > JOIN uploaded_files AS uf ON orders.order_id = uf.order_id > ORDER BY orders.order_id DESC > LIMIT 100 > > HTH, > John W > > >> >> thanks for any help. >> >> -afan >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> >
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
