[SOLVED] automatic 'id'

[stuart7398]

hi.

i require my users to send data to me, once their data is verified by a human i then give them the second part of the form to complete their profile.

 

how would i assign them an automatic 'id' for them to use in order for me to keep their data details together for when they complete the second part of the form?

 

any help / tutorials would be grateful.

 

thanks,

Stuart.

[AndyB]

A database with an auto-incrementing id would do nicely.

[stuart7398]

thanks. maybe i worded my question wrong.

 

i meant, how would i get that 'id' to show up in my thankyou page?

 

thanks,

stuart. 

[kevin7]

i helped to do some search in google, this is pasted from one of the poster.

 

so, i assume you hv set the id column to auto increment..

 

$query = mysql_query("SELECT MAX(id) FROM `table`");
$results = mysql_fetch_array($query);
$cur_auto_id = $results['MAX(id)'] + 1;

 

more detail on http://codingforums.com/archive/index.php?t-94437.html

do search google!

[ohdang888]

no kevin..... you never get the array.

 

making the colunm auto increment deos that all for you...

 

no need to insert or update that column AT ALL.