SQL SELECT while INSERTING
| From: | Asendorf, John | Date: | Wed, 06 Dec 2000 19:41:33 +0000 |
| Subject: | SQL SELECT while INSERTING | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-4332@lists.php.net to get a copy of this message | ||
Hello all,
Have a quick question. Can I select an auto-incrementing key at the same
time I am 'inserting into' a new record...
using Access ODBC
like this
$sql = "INSERT INTO blocked (page,name,email,attempt) VALUES
('$page','$name','$email','$attempt')
AND GET THE KEY FROM THIS ENTRY HERE
;";
Thanks all,
John
---------------------
John Asendorf - jasendorf@lcounty.com
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur.