0

Hi I'm getting this error, sql query is Ok, here is my code.

$query = "INSERT into members VALUES(NULL,'$fname','$sname','$gender','$status','$dob','$phone','$address','$email','$chapter','$join_date','$cell')";

$result = mysql_query($query,$connection) 
    or show_error();

    echo $result;

$new_member = array();
$new_member = mysql_fetch_array($result) 
    or die (mysql_error());
echo 'new_member =', $new_member;
mysql_close();
return $new_member;

}

John Woo
  • 249,283
  • 65
  • 481
  • 481
Nash
  • 1
  • 2
  • Here's the error: Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in – Nash Feb 08 '13 at 06:28
  • 1
    Possible duplicate [mysql_fetch_array() expects parameter 1 to be resource, boolean given in select](http://stackoverflow.com/a/11674313/250259) – John Conde Feb 08 '13 at 06:28
  • 1
    Possible dup: http://stackoverflow.com/questions/5473981/warning-mysql-fetch-array-expects-parameter-1-to-be-resource-boolean-given-i – sgeddes Feb 08 '13 at 06:29

1 Answers1

0

Single quote near variable has to be removed and the $query should be

"INSERT into members VALUES(NULL,$fname,$sname,$gender,$status,$dob,$phone,$address,$email,$chapter,$join_date,$cell)";

user170851
  • 375
  • 5
  • 6