join statments in php

[yobo]

hey all,

 

i have mysql as my database and i am using the myisam feature and i have set up FK in them however they are not joined as they would if i where using innob or somming like that.  and i have to use the join statment in php, however i am not sure on how to use the join statment and i wanted to know if any one know of any good sites for tutorials explaing how to perfrom the join statment in php

[Psycho]

Your question is vague at best. I think you want the MySQL JOIN function which is for joining tables in a database query. There is a JOIN function in PHP but it is just an alias of implode which is an array function.

[Gruzin]

Here is the basic join example:

 

$sql = mysql_query("SELECT table1.field1,table2.field2 FROM table1,table2 WHERE table1.field1=table2.field2");

 

Edit: mjdamato is right, this is a MySQL JOIN function.

 

Regards,

George