Help with $_SESSION['id']

[Bike Racer]

I'm having problems with the data from $_SESSION['id'] carrying over to the next page.

 

Script of first page-------

<?php

 

require_once("Connections/testserver.php");

 

session_start();

 

//Catch Field Data

$userid = $_POST['userid'];

$password = $_POST['password'];

$submitted = $_POST['submitted'];

 

if ($userid && $password) {

/////////////////////////////////////////////

$query = sprintf("SELECT * FROM night where user_name='$userid' and user_password = '$password'");

$result =    mysql_query($query);

$rowAccount = mysql_fetch_array($result);

/////////////////////////////////////////////

}

if ($rowAccount) {

 

$_SESSION['id'] = $rowAccount['user_id'];

 

header("location:success.php");

exit;

 

 

}elseif($submitted){

 

echo "You don't exist on our database";

}

 

?>

 

and for the second page-----------

 

<?php

require_once("Connections/testserver.php");

 

session_start;

 

if (!isset($_SESSION['id'])){

 

header("location: mylogin.php");

exit;

 

}

 

$id = $_SESSION['id'];

 

////////////////////////////

$query =sprintf("SELECT * FROM night where user_id='1'");

$result =mysql_query($query);

$rowAccount =mysql_fetch_array($result);

/////////////////////////////

 

 

?>

 

 

[DarkWater]

On the second page, you have only session_start, but you need session_start();, because it's a function. =)  Simple error.  I don't know why PHP didn't flag it or something.

[Bike Racer]

Missed () after many times of re-trying the script. Still doesn't work though. Any other ideas?