Session variables

[gabemcmillan]

I am having trouble using some session variables across on another page. I can pull my $_SESSION['user_id'] across fine, but the city, state, and zip are blank. Do I need to initialize them or something? Any suggestions?

Here is a snippet from my user login:

 $query = "SELECT id, username, password, city, state, zip 
 					FROM user_info 
 					WHERE username = '" .$_POST['username'] . "' 
 					AND password = (password('" . $_POST['password']. "'));";
 $result = mysql_query($query) or die(mysql_error());

 if ($row = mysql_fetch_array($result) )
 {
 			session_start();
 			$_SESSION['user_id'] = $row['id'];
 			$_SESSION['user_city'] = $_row['city'];
      $_SESSION['user_state'] = $_row['state'];
      $_SESSION['user_zip'] = $_row['zip'];
      $_SESSION['user_logged'] = $_POST['username'];
      $_SESSION['user_password'] = $_POST['password'];

      header ("Location: " . $_POST['redirect'] . "");

[Roger_Ramjet]

'Syntax' problem: you are coding $_row instead of $row.

Remember to use session_start() on any page that wants to access session vars.

[gabemcmillan]

thanks!