create custom autonumber in mysql using php possibly?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

User avatar
McInfo
DevNet Resident
Posts: 1532
Joined: Wed Apr 01, 2009 1:31 pm

Re: create custom autonumber in mysql using php possibly?

Post by McInfo »

This last line is not a typo. It matches the parenthesis from line two and gives the sub-query a required alias.

Code: Select all

) `s`
This comma should not be here without additional fields.

Code: Select all

        ),
    
    FROM
Is IDNumber the only field in your table? Please, explain the theory of your system.
cjkeane
Forum Contributor
Posts: 217
Joined: Fri Jun 11, 2010 1:17 pm

Re: create custom autonumber in mysql using php possibly?

Post by cjkeane »

i was merely trying to get the autonumber/PK to be generated properly on its own before adding in the rest of the fields to the script. i have a bunch of other fields such as firstname, lastname, address, phone, which all go into a records table along with the custom ID number.
.
Post Reply