why doesnt this work.. setting sessions...

[Rifts]

page 1 is this

session_start();
include 'db.php';

$email = $_POST['email'];
$password = $_POST['password'];

$email = stripslashes($email);
$password = stripslashes($password);
$email = mysql_real_escape_string($email);
$password = mysql_real_escape_string($password);	

$sql="SELECT * FROM directory WHERE email='$email' and password='$password' ";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){

$wtf="SELECT * FROM directory WHERE email='$email' and password='$password' ";
while($row = mysql_fetch_array($wtf))
  {
	$fname = $row['fname'];
	$lname = $row['lname'];
	$address = $row['address1'];
	$city = $row['city'];
	$state = $row['state'];
	$zip = $row['zip'];
  }
  
$_SESSION['user'] = $email;
$_SESSION['fname'] = $fname;
$_SESSION['lname'] = $lname;
$_SESSION['address1'] = $address;
$_SESSION['city'] = $city;
$_SESSION['state'] = $state;
$_SESSION['zip'] = $zip;
$_SESSION['status'] = "1";

 

page two is just: only the user and status works.

session_start();

echo $_SESSION['user'] ;
echo $_SESSION['fname'] ;
echo $_SESSION['lname'] ;
echo $_SESSION['address1'];
echo $_SESSION['city'] ;
echo $_SESSION['state'] ;
echo $_SESSION['zip'];
echo $_SESSION['status'];

 

why is that not working

 

[Minimeallolla]

theres no input? its all output?

[Rifts]

there is no output except for the session[user] and session[status] field

[jdavidbakr]

So do you know that the query to pull the info is actually pulling a row?

[Minimeallolla]

what does the error message say?

[Rifts]

there is no error

 

also i think i figured it out i needed to add mysql_query

[ManiacDan]

Haha, yes, that would do it.  You don't actually run the query.

 

Also, a debugging tip:  Read your post and your first response.  You are saying "here is a script that's designed to store some database data in the session.  The only thing being stored is the data from outside the database loop.  What is the problem?  The problem, clearly, is the database loop. 

 

Turn error_reporting all the way up, you would have gotten an error from the mysql_fetch_array line.

 

Echo what you think might be a problem.  if you had put an echo inside that loop, you would have known beforehand that it wasn't running.

 

-Dan

[Minimeallolla]

try something like this

$session = "$zip <br > $state <br> $city <br> $address <br> $lname <br> $fname <br> ";
echo $session

that will compress it anyway... lol

[ManiacDan]

Minimeallolla is using the wrong variable name and the wrong method for setting multiple data points into a single variable.  Your problem is the lack of mysql_query.

 

-Dan

[PFMaBiSmAd]

You are already executing that query once in the code. There's no point in executing it a second time on the same page.

[ManiacDan]

Right, get rid of $wtf entirely and use $result.