Re: LAST_INSERT_ID?????

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



In article <E9E12A91DAEB374493D8501FE29552FD02422BB9@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>, 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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux