execute SQL and set a session

[jarv]

hi,

 

I am having problems setting a session from a SQL query, please help... here is my code:

 

$query1 = "SELECT * FROM members_copy WHERE rsUser = '$username' AND rsPass = '$password'";
$result1 = mysql_query($query1);
echo "<br>".$result1['USERID'];


$_SESSION['s_logged_n'] = 'true';
$_SESSION['s_username'] = $username;
$_SESSION['USERID']=$result1['USERID'];
$_SESSION['RSTOWN']=$result1['RSTOWN'];
$_SESSION['RSEMAIL']=$result1['RSEMAIL'];
$_SESSION['RSUSER']=$result1['RSUSER'];

 

no sessions are currently being set?!

:-\

[BlueSkyIS]

do you have session_start() at the top of the code?

[KevinM1]

mysql_query only executes a query.  It doesn't give you access to the result set.  For that, you need to fetch the results: mysql_fetch_array or mysql_fetch_assoc

[jarv]

ok so I changed my code to

$query1 = "SELECT * FROM members_copy WHERE rsUser = '$username' AND rsPass = '$password'";
$result1 = mysql_fetch_array($query1);
echo "<br>".$result1['USERID'];

 

and now I get the following error:

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\mypubspace.com\wwwroot\mobile\dologin.php on line 19

[Maq]

You forgot to call mysql_query.

[jarv]

thankyou!