question
Posted: Tue Nov 22, 2011 8:46 pm
Hi everybody,
I couldn't print a column of database in the code below. Please help me.
I couldn't print a column of database in the code below. Please help me.
Code: Select all
$query = "SELECT UserId, FirstName, LastName, UserName, Password FROM User WHERE User.UserName =
'".$_POST["username"]."' AND User.Password = '".$_POST["password"]."'";
$result = mysql_query($query) or die('Query failed');
if (mysql_fetch_row($result)){
$cnt = mysql_num_rows($result);
$row = mysql_fetch_array($result);
while($row = mysql_fetch_array( $result )) {
echo $row['FirstName']; [b]<------------ This doesn't work[/b]
}
}