Autonumber Problem

[cswales]

I have a problem with a php form and autonumber.

My SQL table generates an autonumber for each record within the quote table. When adding a new record via the php form I would like to display the autonumber from the database (but this does not generate until I submit the form).

Does anyone have an idea how I get the next autonumber and display in a field within a form.
The code is too long to post here but if anyone would like to see then I can send to them.
Thanks in advance.

[thorpe]

the mysql_insert_id() function will get the last inserted id for you... but like you said, this number isn't generated until after the insert.

[devinemke]

if the field is set to auto_number why then do you want to display it in a form field to the user? if the user changes the value then you run the risk of the query failing (if they choose a number that already exists in the table). don't allow users to input data that you wish to control server-side. display the form, do the INSERT and then use [man]mysql_insert_id[/man] to get the id (if necessary).

[cswales]

Why I need the autoid is for the following:

I have 4 image upload fields. The value of the id field creates the beginning of the uploaded file name. The reason for this is that you can easily see what uploaded files relate to what quotation.

Or is there a way I can declare the autonumber field of the database as a variable within my php code. The autonumber does not have to be displayed but needs to be available within the code.

Hope this makes sense.

[devinemke]

1. upload the files, they will be given a temp name automagically by PHP
2. do the db insert
3. grab the insert id using [man]mysql_insert_id[/man]
4. [man]rename[/man] the file using the newly created id number

[LoganK]

Somewhere in phpMyAdmin once I saw an option for "resetting" the auto_generate id number, and it had the current one, I just don't know how it got it...

I'd go with devinemike's suggestion.