Re: need help to build a query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux