Am I incorrectly handling the mysql resource handle/array?

[scrupul0us]

	if(mysql_num_rows($result) > 0)
	{
		$row = mysql_fetch_array($result);

	$uid = $row['id'];		
	unset($_SESSION['error_msg']);
	$_SESSION['valid'] = TRUE;
	$_SESSION['username'] = $row['user'];
	$_SESSION['fname'] = $row['fname'];
	$_SESSION['lname'] = $row['lname'];
	$_SESSION['email'] = $row['email'];
	$_SESSION['lastlogin'] = $row['lastlogin'];		

	mysql_query('update users SET lastlogin=NOW() where id='.$uid);		
	header("Location: index.do");
}

this fires when a valid user logs in... however, all my session variables come out empty... am i killing the mysql array/handle when doing the row checking?

any ideas?

[devinemke]

obvious question: are you calling [man]session_start[/man]?

[scrupul0us]

yup its in my header...

i did resolve the issue however, the examples i use for quick insertion of DB stuff had a typo and i was using:

$row = mssql_fetch_array($result);

instead of

$row = mysql_fetch_array($result);

i changed it in the code here but a brain fart kept me from editing it in my code 😉