I have two questions:
1. Can anyone tell me whether the following statement is true or false?
The PHP function mysql_insert_id() differs from the MySQL function
LAST_INSERT_ID() in that the PHP function returns the last
auto-incremented value from the current connection, and the MySQL
function returns the highest current value in a table's AUTO_INCREMENT
column.
2. Secondly, if anyone could answer the following question it would be
very helpful...
When updating a foreign key (in-between table for many-to-many
relationships) using the last auto-incremented value, is it better to
write several separate SQL queries and store them in the same variable
for mysql_query(), or is it better to write several separate SQL queries
and store them in separate variables, and then run separate
mysql_query() functions against those variables separately?
IOW, ex 1:
$sql = "INSERT INTO table1 (column2, column3) VALUES ('value1',
'value2')
INSERT IGNORE INTO table2 (column1, column2) VALUES
(LAST_INSERT_ID(), '$id')";
$result = mysql_query($sql);
OR, ex 2:
$sql1 = "INSERT INTO table1 (column2, column3) VALUES ('value1',
'value2')";
$result1 = mysql_query($sql1);
$last_inserted = mysql_insert_id();
$sql2 = "INSERT IGNORE INTO table2 (column1, column2) VALUES
('$last_inserted', '$id')";
$result2 = mysql_query($sql2);
In other words, when performing multiple SQL queries simultaneously, is
it better to give them their own variable (each SQL statement), or can
you lump them all together?
Thank you,
Erik
----
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
