Posted by Frank Arensmeier on 03/08/05 13:35

Hi,

MySQL is capable of doing very complex queries. You could boil down
your query into just one single line:

'SELECT * FROM table1, table2 WHERE table2.field2 = table1.field1'

A good starting point would be the MySQL manual.

I would also strongly recommend you to take a look at the PHP manual
for information about connecting to a MySQL database from PHP, gaining
results and processing these results.

If you could post some PHP code to this list, I am sure members of this
list will gladly help you with debugging the code.

Regards,

Frank

2005-03-08 kl. 11.26 skrev K Karthik:

> 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
>
________________________________________________
Frank Arensmeier
Marketing Support

NIKE HYDRAULICS AB
Box 1107
631 80 Eskilstuna
Sweden

tel +46 16 82 34
fax +46 16 13 93 16
email: frank.arensmeier@nikehydraulics.se
www.nikehydraulics.com

[Back to original message]