Hi,
I need to set session variables. The source of the variables is in two different pages.The data for setting the session variables must be accessed from a database.
What is wrong with my logic?
// page 1 - user variables
<?
session_start();
session_register("NAME");
session_register("STATUS");
// connect , create sql stmt ......
// Execute the Statement
$result=mysql_query($stmt, $link) OR die (mysql_error());
//set variables
wile (($row = mysql_fetch_object($result))){
$NAME = $row->real_name; $STATUS = $row->status;
}
?>
// page 2 - project variables
<?
session_start();
session_register("JOBNO");
session_register("JOBNAME");
// connect , create sql stmt ......
// Execute the Statement
$result=mysql_query($stmt, $link) OR die (mysql_error());
//set variables
wile (($row = mysql_fetch_object($result))){
$JOBNAME = $row->description; $JOBNUMBER = $row->number;
}
?>
// page 3 - test use of variables
<?
session_start();
session_register("NAME");
session_register("STATUS");
session_register("JOBNO");
session_register("JOBNAME");
echo ("User🙂;
echo $NAME;
echo ("User Status🙂;
echo $STATUS;
echo ("Project No🙂;
echo $JOBNO;
echo ("Project Name🙂;
echo
?>