Posted by John Nichel on 03/08/05 16:10

K Karthik wrote:
> sir,
> iam new to php i'll explain my problem .if u could help i'll be very
> thankful...
> in my mysql database i have two tables i.e., table1 and table2.
> i have an array of result from one query "select feild1 from table1 "
> i have to use this result in another query.....
> "select field2 from table 2 where field1 = (array of first query iterated)"
> can u help me doing this in php.
> thanks,
> karthik
>

This isn't PHP. Check the MySQL manual. You can construct your query
to select from both tables at the same time, so chances are you don't
need to get data from one table just so you can use that to retrieve
data from another table.

--
John C. Nichel
ÜberGeek
KegWorks.com
716.856.9675
john@kegworks.com

[Back to original message]