Jump to content

Archived

This topic is now archived and is closed to further replies.

NME

Session Problem

Recommended Posts

This is my code:

[code]$query= "SELECT userid, first_name FROM users2 WHERE username='$username' AND password='$password'";
$result = @mysql_query($query);
$row = mysql_fetch_array($result, MYSQL_NUM); //returns the row with that users information in the users2 table.

if($row)
    {
        $_SESSION['userid']=$row[0];
        $_SESSION['first_name']=$row[1];
        $_SESSION['last_name']=$row[2];[/code]

for some reason $row[2] returns nothing (meaning $_SESSION['last_name'] is nothing as well), although $row[1] and $row[0] return the values they intend from my SQL table. why won't row[3] or any subsequent rows show?

thanks.

Share this post


Link to post
Share on other sites
You only selected [b]two[/b] items from the table - those will be the zeroth and first elements of the $row array.

Share this post


Link to post
Share on other sites
ah ofcourse, im an idiot. thanks so much.

should've been SELECT * FROM ...

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.