Re: LAST_INSERT_ID?????
| From: | Tim Van Wassenhove | Date: | Thu, 15 Jul 2004 20:30:12 +0000 |
| Subject: | Re: LAST_INSERT_ID????? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35282@lists.php.net to get a copy of this message | ||
In article <E9E12A91DAEB374493D8501FE29552FD02422BB9@txdlls2msgusr11.itservices.sbc.com>,
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>