Stored variable

[LordShryku]

I'm trying to build a form that will be accessed by many people, and will insert records into a PostgreSQL database. Now, I need to assign a sequential serial number to each record, but I have a problem with this: The form is ten rows of input. If someone enters all ten rows, I will need to do ten inserts, but have the same serial number assigned to each one.

Can anyone think of a way to store like a variable, the last serial number that was used, and add 1 to it each time someone submits the form?

Thanks for all your help 🙂

[dawson1323]

Start a session variable and then do something like:

for ($i = 0; $i < $num; $i++)
{
$id = $session_var . "$i";

blahblah
}

Include the lines for adding the info into your DB in that loop and each line it adds will have sess_var1, sess_var2 and so on.

-D

[LordShryku]

Right, but when that session ends, so will that string. How do I get it to store the last number it used, and start there on the next session?

[dawson1323]

If the user is logged in you can run a query on the last entery recorded and if you make the logged number something like 123896123-10 then you can retrieve that number and

$ep = explode ("-", $var);

Then take $arr = $ep[1]; and start the loop again adding + 1 to each record.

-D