it seems that i have forgotten everything i have learned about msql databases and php, so can some one help me do this or at least tell me how to display it from the database
Have you specified an identity field in the database table which and set the increment and seed?
Also, how are you connecting to the database, PDO, Mssql?
How about you show what you have do instead of asking for a handout?