Help me with correcting Error in mysql_fetch_array() function.

[harshanarayana]

$conn=mysql_connect($dbl,$dbuser,$dbpass);

mysql_select_db("project",$conn);

$result=mysql_query("SELECT * FROM pro0ject WHERE name = '$_POST[fname]'");

echo $result;

while($row=mysql_fetch_array($result, MYSQL_ASSOC))

{

echo $row['name'];

echo "<br>";

echo $row['usn'];

}

 

 

 

Can any one please help me correct the mistake in this code ?

Every time i run this i get an error telling

mysql_fetch_array() expects parameter 1 to be resource, and its boolean in line 10...

 

[deepson2]

Try this

 $sql = mysql_query("SELECT * FROM pro0ject WHERE name = '".$_POST['fname']."'");
if(mysql_num_rows($sql) > 0){
while($row = mysql_fetch_array($sql))
{
echo $row['name'];
      echo "<br>";
      echo $row['usn'];
      

}
}

[trq]

This means your query is failing. mysql_query returns false 9which is a boolean) on failure. You need to always check any results before using them...

 

$fname = mysql_real_escape_string($_POST['fname']);
$sql = "SELECT * FROM pro0ject WHERE name = '$fname' LIMIT 1";
if ($result = mysql_query($sql)) {
  if (mysql_num_rows($result)) {
    $row = mysql_fetch_assoc($result);
    echo $row['name'];
    echo "<br>";
    echo $row['usn'];
  } else {
    echo "No results found";
  }
} else {
  trigger_error(mysql_error() . "\n" . $sql);
}

[harshanarayana]

Hey frnds, thanks a lot for the help... i corrected the errors.... and before that it worked well once whn i reinstalled the lampp service in my system. But later if started giving problems again.. But not after making some changes in code as u said its working like a sweet cake thanks a lot