On Mon, October 9, 2006 2:58 pm, John Wells wrote: > 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 This will "miss" all the orders with no upload at all, unlike the original. AND it limits you to the 100 uploaded files, not 100 orders. This is a lot more subtle problem than it seems at first glance, eh? -- 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
