Retrieving AUTO Increment ID from MYSQL

Question

Hi All,

I am trying to get the ID issued from MYSQL from an Auto
Increment field after an Insert Update command. I keep getting this
error....

Warning: mysql_insert_id(): supplied argument is not a valid
MySQL-Link resource in
/www/mesa/conference/registration/TMP47yo0evkno.php on line 65

Warning: Cannot modify header information - headers already
sent by (output started at
/www/mesa/conference/registration/TMP47yo0evkno.php:65) in
/www/mesa/conference/registration/TMP47yo0evkno.php on line 67

Plus once I get the ID, can someone help with code to pass
onto the next page.

Thanks!

Newsgroup_User · Answer

sock_s wrote:> I am trying to get the ID issued from MYSQL from an AutoIncrement field after > an Insert Update command. I keep getting this error.... > > Warning: mysql_insert_id(): supplied argument is not avalid MySQL-Link > resource in/www/mesa/conference/registration/TMP47yo0evkno.php on line 65It looks as though you're using your remote server as atesting server. Upload your page to your server and test it there.The following page shows the correct way to usemysql_insert_id():http://www.php.net/manual/en/function.mysql-insert-id.php-- David Powers, Adobe Community ExpertAuthor, "Foundation PHP for Dreamweaver 8" (friends of ED)Author, "PHP Solutions" (friends of ED)http://foundationphp.com/

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.