mysql_insert_id() and JOIN

["Emiliano Boragina" <emiliano.boragina@xxxxxxxxx>]

Hi again?

I dont understand how to use this two?

I read php.net and other sites, but dont understand...

 

I have this four tables: table1, 2, 3 and 4

So the SELECT is like this?:

<?

$query_select = "SELECT * FROM table1 FULL JOIN table2 FULL JOIN table3 FULL
JOIN table4 ON table1.id=table2.id=table3.id=table4.id ORDER BY id ASC?;

mysql_query($query_select);

?>

This is with FULL JOIN... How identificate the left table if I want to use
LEFT JOIN?

How is the UPDATE?

And the INSERT I dont understand yet how is it?

I?m not to do a link between tables in PHPMyAdmin?

 

Thank you very... VERY... much!

+                                                                          _
   // Emiliano Boragina _
   // Diseño & Comunicación //////////////////
+                                                                          _
   // emiliano.boragina@xxxxxxxxx  /
   // 15 40 58 60 02 ///////////////////////////
+                                                                          _