[PHP-DB] mysql_insert_id() and JOIN

[Emiliano Boragina]

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.borag...@gmail.com  /
   // 15 40 58 60 02 ///////////////////////////
+                                                                          _