php-db | 2004071
Date: 07/15/04
- Next message: Justin Patrin: "Re: [PHP-DB] LAST_INSERT_ID?????"
- Previous message: Hutchins, Richard: "RE: [PHP-DB] LAST_INSERT_ID?????"
- In reply to: NIPP, SCOTT V (SBCSI): "[PHP-DB] LAST_INSERT_ID?????"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
In article <E9E12A91DAEB374493D8501FE29552FD02422BB9 <email protected>>, Scott V Nipp wrote:
> I am trying to pull the
> entry number to display for the user as a "ticket number". I would
> assume that I should use the LAST_INSERT_ID function for this.
> Unfortunately, I am getting either failures or all zeroes for this
> output.
> I can't even get this function to work in a SQL query window.
> Please help!!! I would attach code to this, but I am not sure what to
> attach.
Try "SELECT LAST_INSERT_ID() AS id";
-- Tim Van Wassenhove <http://home.mysth.be/~timvw>-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
- Next message: Justin Patrin: "Re: [PHP-DB] LAST_INSERT_ID?????"
- Previous message: Hutchins, Richard: "RE: [PHP-DB] LAST_INSERT_ID?????"
- In reply to: NIPP, SCOTT V (SBCSI): "[PHP-DB] LAST_INSERT_ID?????"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

