Hello Dave,
If your auto-incrementing field in your table are Account_ID for exemple,
try :
Select Account_ID From tablename Where Account_ID = LAST_INSERT_ID();
This work fine for me
Bye
Ghislain Proulx
Web Programmer
Groupe Ordimax
http://www.ordimax.com
http://www.infoteck.qc.ca
> -----Original Message-----
> From: Dave Carter [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 25, 2001 9:49 AM
> To: [EMAIL PROTECTED]
> Subject: LAST_INSERT_ID Issues
>
>
>
>
>
>
>
> This does not return any results
>
> SELECT LAST_INSERT_ID() FROM tablename;
>
> there is an indexed, auto-incrementing field in the table,
> but it refuses to
> show any results. I don't understand the manual's text, so
> any help would be
> appreciated.
>
>
> Dave Carter
> Chief Web Architect
> Accelerated Business Technologies, Inc.
> http://www.abti.cc
> 717.464.2970
>
> grrrr sql,database
>
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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