[RESOLVED] redirect question

[auddog]

I'm trying to redirect via the location command after I do an update to my database. Here is my code:

<?php
include 'config.php';

/*** create a new mysqli object with default database***/
$connection = mysqli_connect($hostname, $username, $password, $dbname) or die ("Unable to connect");


/*** sql to UPDATE a new record ***/
$sql = "UPDATE table1 SET
        job_name = '$_POST[job_name]',
        job_number = '$_POST[job_number]',
        WHERE id = '$_POST[id]'";

//excute query
$result = mysqli_query($connection, $sql) or die ("Error in query: $sql. ".mysqli_error());

// close connection
mysqli_close($connection);

header("Location: ada_project_info.php?id=$id");

?>

I know that it's something small, but I can find it. Thanks for helping me out.

A

[mikawhat]

so what's seems to be the problem?

[auddog]

when i run the page it will go to the page

http://localhost/ada/ada_project_info.php?id=

it never fills in the id variable

A

[mikawhat]

i guess is because there's no value for $id ... try $id = $_POST['id'];

[auddog]

I changed it to id=$_POST[id] and that ended up working - thanks for the help it is greatly appreciated.

A