Re: php-help

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