[aosman1]

Hey,

I am trying to get a MySQL entry to be associated (pulled out and displayed) with another entry in another table. How can I make PHP do that?

If this is possible, can I associate many entries from a table to other another entry in a different table?

Thanks

a.osman

[Bonzo]

You can do this although I have never tried.

I would guess that if you do two mysql querys; one for each table you would get the info.

To make it easyer for yourself I would have two columns with the same data in in each table to give yourself a referance ! and dont have the same column names in both tables.

e.g. SELECT * FROM table_1 WHERE name = 'dave' ;
SELECT * FROM table_2 WHERE forname = 'dave' ;

Anthony

[the_mole001]

Hey,

If you truly want to understand the beauty of joining point your browser to:

http://www.devshed.com/c/a/MySQL/Und...ing-SQL-Joins/

and read up on all the exciting ways of joining mysql tables to get your desired result lol

Peter