hi i have a form that submitts infrormation into the database i want to have something where by each time a user submitts a form they are assigned a number automatically into the database? nothing complex like guest no1
then next person guest number 2 etc . can some one tell me how i can do this an give an example if possible please

thanks

Create and query to look at the number field within your db.. then
create a script that add one to the next number example
$sql = "SELECT num FROM DB ORDER BY num DESC";

// latest number within db
$num = $row['num'];

// set this number to enter in db for new user
$num = $num++;

I hope this is kind of what you are looking for.

Just create a new field in your table. Call it ID, and set to auto_increment. It will basically give an id number for every post.