php select clause error Please HELP?

S

shamil j

New member
when i write the following code it appears to be in the following format;
print_r(mysql_fetch_row ($result));

the output is Array ( [0] => ve2 )

but when i try to save (mysql_fetch_row ($result)) to $row, i dont see anything getting printed as the output.


$sql="SELECT LastName FROM userdeck WHERE Firstname = '".$q."'";

$result = mysql_query($sql);
$row = (mysql_fetch_row ($result));
while($row)
{
echo "<tr>";
echo "<td>" . $row['Firstname'] . "</td>";


echo "</tr>";
}

Can some one help me code this.

I am using windows vista sp2 . MySQL version 5.1.54-community MySQL Community Server (GPL)
 
Back
Top