Selecting fields from a database, problem.

[aaron118]

I am trying to create a login script. I am having a problem though when trying to select certain fields from a database and then output them.

Here is the part of the code which is causing the problem.

	$query = "SELECT customerid, firstname, lastname FROM customers WHERE username='".$_REQUEST['username']."' AND userpass='".$_REQUEST['password']."'";
	$result = mysql_query($query);
	$num_rows = mysql_num_rows($result);

if($num_rows != 1) {
echo("That username and password does not exist in our database. Please go back and try again.");
exit;
}

if($num_rows = 1) {
session_start();
$_SESSION['customerid'] = mysql_result($result,"customerid");
$_SESSION['firstname'] = mysql_result($result,"firstname");
$_SESSION['lastname'] = mysql_result($result,"lastname");
header( "Location: /testpage.php" );
} else {
echo("That username and password does not exist in our database. Please go back and try again.");
}

For some reason when I try and echo my information like say $SESSION['firstname'] and $SESSION['lastname'] both of their values will just be the same as the customerid value. Which is not correct. Whichever field comes first in the query like customerid is first, the other two fields use the value of that first one. Which is not correct. Why is it doing this?

Thanks

[planetsim]

I dont use [man]mysql_result[/man] (You may want to check the Manual for some comments firstly). I use [man]mysql_fetch_array[/man] which will work better in this situation instead of calling MySQL for field values numerous times.

[aaron118]

Ok I tried your suggestion, but still get a problem with it. This time whichever field comes first in the query like customerid is first, that is the only field that has a value (which is the correct one). The other two just have blank values unlike the other method I used where the other two used the same value as the field which comes first in the query.

Please help and thanks!