Last Variable in column

rotwyla98

i have a simple script where u input ur name, birthday, and favorite color, click submit and it writes in ur info and displays it. The problem is that i set the friend id to be unique and therefore cant be reused. I dont want the person to make up there own id, i want it to be the next consequetive #. Is there a way to find the largest number in the array and add 1 to it?

Thanks in advance

EDIT:

Heres the link to it:
www.wmtoolbox.com/friends.php

laserlight

I dont want the person to make up there own id, i want it to be the next consequetive #.

If you're using a relational database, this id should be the primary key and so should be autoincrement.

Is there a way to find the largest number in the array and add 1 to it?

Use [man]max/man, but only if you're not using a relational database.

rotwyla98

hmm... cant figure out how to use the max command

would this be the way to do it?

while ($row=mysql_fetch_array($sql_result)){
$friendid = max($row["FRIEND_ID"] + 1);
}

Weedpacket

Get all of the FRIEND_ID's, and use max() on them. Then add one.

rotwyla98

how would i use max()... can u please provide an example?

intenz

SELECT MAX( FRIEND_ID ) AS maxfid FROM table WHERE ...

maxpup979

and that works dandy unless you happen to have 2 people who request the ID at the same time. Thus, use a transacational system, and ask for the next value--the transaction system should lock on that value, and when the next person requests one (even if they are at the same time), then they will get a different value.

homer09001

i use the kinda of thing your on about on my site the user joins my site and they are automattically assigned an ID No

to do it simply on your html form and simply add this to the top of your html form:

then in your database that all the other info goes into open that table add a new field called "userid" make it "INT" "NOT NULL" and "AUTO INCREMENT"

now in the php file assuming you use 1 to add the data to your database find the bt where it enters all the info in and at the beggining of teh INSERT command before your first variable and add '$userid',

hopefully this should do the job