user id count

[Mike431]

Excuse my ignorance. I'm really new to all of this.

I have a table that includes user ids and usernames

ie.

user_id username
0 mike431
1 jane416
2 Sam414
3 Pete334

---

I need a php script that will query the last user_id in the table (3 in this example) and add 1 to it.

So when I input another user via my webpage, their user_id would be 4.

Help appreciated.

[devinemke]

let your database do this for you. set the user_id to auto_increment.

[Mike431]

Originally posted by devinemke
let your database do this for you. set the user_id to auto_increment.

done...wow that was simple.

Thanks