Session Problem

[NME]

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.

[AndyB]

You only selected [b]two[/b] items from the table - those will be the zeroth and first elements of the $row array.

[NME]

ah ofcourse, im an idiot. thanks so much.

should've been SELECT * FROM ...