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.
Ben
--
****************************************************************
* Ben Edwards Tel +44 (0)1179 553 551 ICQ 42000477 *
* Homepage - nothing of interest here http://gurtlush.org.uk *
* Webhosting for the masses http://www.serverone.co.uk *
* Critical Site Builder http://www.criticaldistribution.com *
* online collaborative web authoring content management system *
* Get alt news/views films online http://www.cultureshop.org *
* i-Contact Progressive Video http://www.videonetwork.org *
* Fun corporate graphics http://www.subvertise.org *
* Bristol Indymedia http://bristol.indymedia.org *
* Bristol's radical news http://www.bristle.org.uk *
****************************************************************
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
