mysql_insert_id() and JOIN
| From: | Emiliano Boragina | Date: | Sat, 11 Jul 2009 04:58:05 +0000 |
| Subject: | mysql_insert_id() and JOIN | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-46268@lists.php.net to get a copy of this message | ||
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?
Im not to do a link between tables in PHPMyAdmin?
Thank you very... VERY... much!
+ _
// Emiliano Boragina _
// Diseño & Comunicación //////////////////
+ _
// emiliano.boragina@gmail.com /
// 15 40 58 60 02 ///////////////////////////
+ _