Thanks to all for the responses. Especially to those who pointed
my to documentation.
Regards
-tim-
* Cliff <[EMAIL PROTECTED]> [021108 08:32]:
> You can use the function : mysql_insert_id() to get the value you've just added.
> Please see http://www.mysql.com/doc/en/mysql_insert_id.html for more information.
> Notice that you should call mysql_insert_id() immediately after the query that
>generates the value.
>
> ----- Original Message -----
> From: "Tim Johnson" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, November 09, 2002 1:04 AM
> Subject: Returning an Auto-Increment Field
>
>
> > Hello All:
> > If I am adding a row to a table that has an auto-increment field,
> > is there a way to query MySQL for the value of that field, once the
> > new row is added?
> > TIA
> > --
> > Tim Johnson <[EMAIL PROTECTED]>
> > http://www.alaska-internet-solutions.com
> > http://www.johnsons-web.com
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
http://www.johnsons-web.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
