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