Ben Edwards wrote:
On Thu, 2003-10-09 at 16:33, pete M wrote:
$new_id = mysql_query('select last_insert_id()');
your can also user it within a query - eg
$sql = ' insert into related table parent_id, data , data2) values (last_insert_id(), 23, 45);
Is there also a similar way of getting the last error message, i.e.
$new_id = mysql_query('select error()');
I currently am trying to solve the problem or mysql_error() returning nothing after an error. It may be something to do with globals and something like the above may help.
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php