Session Error... weird??

ofSHIZ

Hi.. I use this code for alot of my scripts.. and now that I am making a new website.. it all of the sudden just goes bad. I don't know why...

<?php
session_start()


?>
<?php
$session = session_id();

$db = mysql_connect("xxx","xxxxxxx") or mysql_die ("Unable to Connect to Mysql.. please contact Brandon about this!"); 
  mysql_select_db("lipside",$db);

$sql = mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password'");  

if(mysql_num_rows($sql) == 1) {
while($row = mysql_fetch_array($sql)){

$username = $row['username'];
$password = $row['password'];
$email = $row['email'];
$aim = $row['aim'];
$real_name = $row['real_name'];
$_SESSION['username'] = $username;
$_SESSION['password'] = $password;
$_SESSION['aim'] = $aim;
$_SESSION['email'] = $email;
$_SESSION['real_name'] = $real_name;
echo "<meta http-equiv='refresh' content='1;URL=membersarea.php?$session'>";
} 
}
else {
echo "Wrong Username or Password. Please login again.<br>"; }


?>

I know it is not session'ing because when it directs itself to membersarea... it doesnt display any data...

phpprogrammer

Dear Friend,

plz explain your problem indetail

regards
bvsureshbabu

trooper

On the page that you are re-directing to do you have session_start() at the top?

Also are you storing your sessions as server side cookies, if not then you will need to pass the session id in the url

HTH

ofSHIZ

Okay.. to put this in detail... umm this script is the login verification.. so when a user logs in.. it will verify it and then if it is correct.. it will make it a session

yes the page i am re directing to has session start

how to i check to see if I am using server side cookies? It weird... this script worked on my other website.. but on this one it doesnt work.. weird?

I am also using frames
http://www.lipsideskatekrew.com/index2.php
go down to the very bottom near the copyright... move your mouse over a little bit from that is the login screen... you can login with guest//guest

ofSHIZ

Wait I think i figured out why...

$sql = mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password'");

its only selecting the username and the password... so it is not selecting all of the other variables so it cant session it.. hold on let me add something

Steveo31

Sorry in advance for the newb question, but isn't mysql_fetch_array a 2 parameter function? Don't you need to define the type of array such as MYSQL_NUM or MYSQL_ASSOC?

Weedpacket

Originally posted by Steveo31
Sorry in advance for the newb question, but isn't mysql_fetch_array a 2 parameter function? Don't you need to define the type of array such as MYSQL_NUM or MYSQL_ASSOC?

Short answer: no. Longer answer, you can, but if you don't specify anything the resulting array will contain the data under both numeric and associative indicies.

HalfaBee

Try doing a session_write_close() before the redirect.