J Bug asked 2 years ago
Hi everyone, Im trying to create a form entry via PHP - and in the original form, I have an [auto_id] increment for one of the fields..
When I create one manually via PHP, how do I get the field to also go up 1, based on the last entry that was created for that field?
I cant seem to locate the PHP to pull that number, and then just +1 to it...
Any help? Thank you!
Rob LeVine Staff answered 2 years ago
While you'll ultimately make the call in PHP, it's a MySQL command you're looking for something like this
SELECT auto_increment FROM information_schema.tables WHERE table_name='<your table name>';
Please login or Register to submit your answer
