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@xxxxxxxxxxxxxxxxx www.nikehydraulics.com
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
