Folk, I know this is an old query, but still, problems . . .
I've tried these both, but something is amiss - probably my interpretation. Every time I try to use LAST_INSERT_ID() I get a complaint that the query has a problem. E.G., $qry=$qry.";select LAST_INSERT_ID();" will blow up on me every time I've evaluated $qry, and it works just fine until I append the piece that should let me recover the auto increment value that was created during the insert process. I'm using, according to phpinfo(), MySQL 3.23.32 and PHP 4.0.5 on Win2K with IIS 5.0. I've dredged up everything I could find, but nothing I've tried seems to work. I've created tables specifically for the purpose of testing, with no more than an ID field and a character field, to ensure that I wasn't encountering some other insert problem. I'm quite at wit's end here, and hope that one or more of you can show me where I've gone astray. Make a good day . . . . . . barn ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Some men are discovered, others are found out!! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --------------------------------------------------------------------- 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
