echo integer from table with mysql

Question

I'm building a user database for my website. One of the table columns is "id" where the user is given a reference number. In order to add new users, I have to select the last-registered user, extract the ID, add 1 to it, then submit that back into a new row for the new user. I'm currently using:

$query = mysql_query("SELECT MAX(id) FROM users;");

to select the maximum ID number. When I added 1 to that and tried to echo, it printed "Request ID#3" in the browser.

How do I write a script that will take the highest ID, add one, and use it for the new registering user?

Why don't you use AUTO_INCREMENT on that column instead?

Stefan H
– Stefan H

2011-01-15 05:02:46 +00:00
Commented Jan 15, 2011 at 5:02 — Stefan H
– Stefan H, Commented Jan 15, 2011 at 5:02

amosrivera · Accepted Answer · 2011-01-15 05:02:25Z

3

You need to use mysql_fetch_array() first before echoing the result like:

$query = mysql_query("SELECT MAX(id) FROM users;");
$result = mysql_fetch_array($query);

echo $result["id"];

BUT this is not necessary you can set the field to auto increment and it will add 1 automatically everytime your insert somtehing in the DB. Read more about it here:

http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html

answered Jan 15, 2011 at 5:02

amosrivera

26.6k9 gold badges70 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

echo integer from table with mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related