PHP mysql select

[bgraybr]

What I'm trying to do is generate a unique id for every user on the site.

I want this script to select the highest id and raise it by one, but when I run the script "$myfetch" and "$genid" are always equal to 1 no matter what.

I know that the mysql query is correct because I used it in phpMyAdmin and it worked fine.

//generate an id
$query = mysql_query("SELECT userid FROM users ORDER BY userid DESC LIMIT 1");
$myfetch = mysql_fetch_array($query);
$genid = (int)$myfetch++;

[Jon-86]

As far as I know you can't simply cast and array as an int! Why not use auto increment or simply generate a random number using the system time as the seed value...

[Aksumka]

Like Jon-86 said, you can set the row userid to auto_increment. Every time a new user is created it will automatically make the next ID one higher than the last.

If you want to get the highest userid, you could use MAX:

$maxID = mysql_query("SELECT MAX(userid) AS maxID FROM users");
$maxIDQ = mysql_fetch_array($maxID);

I'm not an expert in this, but I am using this in a stat generating file on my site.

[bgraybr]

At 7/28/09 06:58 PM, Jon-86 wrote: As far as I know you can't simply cast and array as an int! Why not use auto increment or simply generate a random number using the system time as the seed value...

Fixed, I didn't know about auto increment...

[LostVoices]

At 7/28/09 07:15 PM, bgraybr wrote:

At 7/28/09 06:58 PM, Jon-86 wrote: As far as I know you can't simply cast and array as an int! Why not use auto increment or simply generate a random number using the system time as the seed value...

Fixed, I didn't know about auto increment...

Just about Database i've used i alwaays have Id Auto increment and Primary Key :)

[Thomas]

At 7/28/09 07:15 PM, bgraybr wrote: Fixed, I didn't know about auto increment...

Every time you insert something into table, the new entry will have +1 higher than last. Hurrah!

[henke37]

While you are learning new things, learn parameterized queries, you sound like the kind of guy who would forgot escaping stuff. With parameterized queries, you will never have to worry about sql injections. However, you need a serious database extension to use those. PDO and mysqli is two extensions for php that does support it. Look for "prepared queries", the name of the implementation technique.

[rockymeet]

If you want a unique Id for every person . you can use data of field primary key in mysql.
and I hope your problem can be solved thank for join us.
----
FriendyAnil

[Relish]

At 7/30/09 04:38 PM, rockymeet wrote: If you want a unique Id for every person . you can use data of field primary key in mysql.
and I hope your problem can be solved thank for join us.
----
FriendyAnil

Work on your English a bit, and put FriendyAnil or whatever in your signature.

And he's not really "joining us"..