Sep 23, 2004 #1 mousematt MIS Feb 5, 2001 102 GB Hi, What I want to do is insert a new record into a MySQL db and then get the id for that row returned. Does anyone know how to do it? Thanks
Hi, What I want to do is insert a new record into a MySQL db and then get the id for that row returned. Does anyone know how to do it? Thanks
Sep 23, 2004 #2 Olavxxx Programmer Sep 21, 2004 1,134 NO Hi, Please read this: http://dev.mysql.com/doc/mysql/en/mysql_insert_id.html Good luck! Upvote 0 Downvote
Sep 23, 2004 #3 Olavxxx Programmer Sep 21, 2004 1,134 NO this one is good for php too: http://no2.php.net/manual/en/function.mysql-insert-id.php Upvote 0 Downvote
Sep 23, 2004 Thread starter #4 mousematt MIS Feb 5, 2001 102 GB You are a star. Works fine thanks Upvote 0 Downvote
Sep 23, 2004 #5 Olavxxx Programmer Sep 21, 2004 1,134 NO no problem... just shout out if anything other arrises. -Olav Upvote 0 Downvote