WHAT AM I DOING WRONG???

[Lucky2710]

$result3 = mysql_query("SELECT User_ID FROM leaderboards WHERE User_ID = '$user'");

if(mysql_num_rows($result3) == 0){

	$query1 = "INSERT INTO leaderboards (User_ID, CollegeFootballPoints) VALUES ('$user','$points')";
	$result1 = mysql_query($query1);

}else{

	$query2 = "UPDATE leaderboards SET  CollegeFootballPoints='$points' WHERE User_ID='$user'";
	$result2 = mysql_query($query2);
}

 

I keep getting this error...'

 

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in update_collegeFBpoints_points.php on line 40

 

And the script is not working!

 

(LINE 40 is

 

$result3 = mysql_query("SELECT User_ID FROM leaderboards WHERE User_ID = '$user'");

if(mysql_num_rows($result3) == 0){

 

specifically mysql_num_rows)

 

 

[wildteen88]

You more than likely have an error with your query. To find out why change

$result1 = mysql_query($query1);

to

$result1 = mysql_query($query1) or die('Query Error!<br />Query: ' . $query1 . '<br />Error: ' . mysql_error());

[Lucky2710]

Alright that told me that my field 'User_ID' was unknown. But that is the field name and it is not misspelled! 

[Lucky2710]

Never mind I'm stupid, i forgot to create that column in the table and i was looking at the wrong table. lol

 

Thanks for your help!

[wildteen88]

I was going to say double check your field names