mysql_num_rows() expects parameter 1 to be resource boolean given in

Question

what is wrong with my query?

$check_select = mysql_num_rows(mysql_query("SELECT * FROM `user` WHERE user_id = '$user_fbid'"));
if($check_select > 0){
    mysql_query("INSERT INTO `user` (user_id, name, photo) VALUES ('$user_fbid', '$user_fnmae', '$user_image')");
}

it returned mysql_num_rows() expects parameter 1 to be resource, boolean given in

Possible Duplicate http://stackoverflow.com/a/17101301/1501051 — عثمان غني, Mar 10 '14 at 08:34

Nazaret2005 · Accepted Answer · 2014-03-10T09:50:55.153

2

$row = mysql_query("SELECT * FROM user WHERE user_id = '{$user_fbid}'");
$check_select = mysql_fetch_array($row);

if($check_select > 0){
    mysql_query("INSERT INTO user (user_id, name, photo) VALUES ('{$user_fbid}', '{$user_fnmae}', '{$user_image}')");
}

AND Stop WORK with mysql! Work with mysqli or pdo

edited Mar 10 '14 at 09:50

answered Mar 10 '14 at 09:08

Nazaret2005

410
3
11

score 1 · Answer 2 · answered Mar 10 '14 at 08:43

Try with following

$check_select = mysql_num_rows(mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE user_id = '$user_fbid'")));
if($check_select > 0){
    mysql_query("INSERT INTO `user` (user_id, name, photo) VALUES ('$user_fbid', '$user_fnmae', '$user_image')");
}

mysql_num_rows() expects parameter 1 to be resource boolean given in

2 Answers2