redirect users to updated page?

[Anon]

Hello,
I have what probably is an easy problem I hope. I am using 2 different PHP3 scripts to generate a list of names and addresses from a mysql db. One script(list.php3) is just pulling out all of the existing data and displaying it, and the other is used to add data(add.php3). What do I need to do to redirect the user back to the list page after the <form action=POST> has been submitted from add.php3. Basically, I just want the user to see the new list with what they entered? I tried to use ACTION=list.php3, but the SQL INSERT statement is never executed?

Thanks

[Anon]

In your add.php3 page do something like this..

<?php

if($submit)
{
mysql_query(INSERT blah blah blah);
header("location: list.php3");
}

else
{
//show form
}

HTH
scott d~

[Anon]

Hello Jay,

add.php3:
1. send the form data to a script which executes the SQL statements
<form action="insert.php3" method="post">
...
</form>

insert.php3:
2. check the submitted data and execute a SQL query which inserts the data into the database (INSERT INTO foo ...) and retrieve the ID of the inserted record by using the last_insert_id () function.

$newID = last_insert_id ();

3. redirect the request to list.php3 by sending a HTTP header using the header () function, send the new ID as part of the query string

   header ("Location: ./list.php3?ID=$newID");

list.php3:
4. check if the variable $ID is set (i.e. the script is invoked by list.php3) and highlight the matching record.

greetings, Keita