Passing variables

[Anon]

Hi Guys,
How can i resolve this.
I have a php script, at the top of this script is a redirection, eg.

<META HTTP-EQUIV="refresh" CONTENT="3; URL=typh_forum1.php?id=<?=$post_id?>">
<?

// script here

Basically the values from a form are sent to this script which inserts data into the database.
This all works fine except for when the script tries to refresh and redirect. The reason it has trouble is because =<?=$post_id?> has no value due to the fact that post_id is an auto_increment field in the database. The data from the form is inserted into the database but i don't know how to pass that post_id value.
I hope this makes sense, any ideas?

Cheers,
Salo

[rrijnders]

What database are you using?

There are functions in most databases for retrieving the next value from auto-increment fields. In you script, do that first and then just insert the retrieved value along with the rest of the row-data. This way, your script will have that value to pass along in the re-direct.

-- Rich

[Anon]

if you are using MySQL, use the mysql_insert_id() function.

[fandelem]

My suggestion: read up on sessions in PHP -- you do not even have to bother trying to manually pass along variables .. all you have to do is 're'start your session and you gain all the variables you've put into the array. it's quite nice and saves lots of time.

this will get you started:

http://www.php.net/manual/en/ref.session.php

cheers,

kyle