Good evening I'm busy making a script but i'm am stuck.... How can i... If i have te results from the first query, use it to find and print other result in other table.... ------------- query results from table A and retreve - Contains Name, telefone, info, Use the name of table A and find in Table B and retreve - Name, Adres, zipcode, while $row mysql_fetch_array($result) Echo all in 1 array - Name (Table A) - Telephone (Table A) - Info (Table A) - Adres (Table B) - Zipcode (TableB) Hope some can help me(im a little noob)
I would probably do a join so that you only need 1 query. SELECT table_1.columns, table_2.columns FROM table_1 LEFT JOIN table_2 ON table_1.Name = table_2.Name;