MySQL Error

[3raser]

PHP Code:

 

	if($revision_p=="317")
	{
	$search_query = mysql_query("SELECT * FROM snippets WHERE title LIKE '%$contents%' WHERE `revision`='317'");
	}
	elseif($revision_p=="474")
	{
	$search_query = mysql_query("SELECT * FROM snippets WHERE title LIKE '%$contents%' WHERE `revision`='474'");
	}
	elseif($revision_p=="508")
	{
	$search_query = mysql_query("SELECT * FROM snippets WHERE title LIKE '%$contents%' WHERE `revision`='508'");
	}
	elseif($revision_p=="525")
	{
	$search_query = mysql_query("SELECT * FROM snippets WHERE title LIKE '%$contents%' WHERE `revision`='525'");
	}
	elseif($revision_p=="530")
	{
	$search_query = mysql_query("SELECT * FROM snippets WHERE title LIKE '%$contents%' WHERE `revision`='530'");
	}
	elseif($revision_p=="562")
	{
	$search_query = mysql_query("SELECT * FROM snippets WHERE title LIKE '%$contents%' WHERE `revision`='562'");
	}
	else
	{
	$search_query = mysql_query("SELECT * FROM snippets WHERE title LIKE '%$contents%'");
	}

	if(mysql_num_rows($search_query) > 0)
	{
		$amount = mysql_num_rows($search_query);
		echo "A total of ". $amount ." results have been found: <br/><br/>";
		while($row = mysql_fetch_assoc($search_query))
		{
			echo "<b><span style='color:red'>[". $row['revision'] ."]</span></b> Title: <b>". $row['title'] ."</b> Date: <b>". $row['date'] ."</b> <a href='view.php?id=". $row['id'] ."'><b>View</b></a><br/><br/>";
		}
	}

 

Error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/a9796960/public_html/snippets.php on line 100

 

I've already checked for reserved words.

[tomtimms]

what happens when you echo out $search_query? 

[tomtimms]

also looks like `revision` needs to be just revision....your query isn't correct.

[PFMaBiSmAd]

You have got two WHERE clauses in your queries. You can only have one. I suspect you wanted to form a logical expression using the AND keyword.

[3raser]

what happens when you echo out $search_query?

 

Well, when I just did the regular query, where it says else - I get this

 

Resource id #6

[3raser]

You have got two WHERE clauses in your queries. You can only have one. I suspect you wanted to form a logical expression using the AND keyword.

 

Oh. Hell, I don't know why I didn't see the first WHERE in there. Thank you.

[PFMaBiSmAd]

Also, why are you writing out all of that repetitious code where only the value is different and you have to write out more code to add another value? Just use an array -

$revisions = array();
$revisions[] = "317";
$revisions[] = "474";
$revisions[] = "508";
$revisions[] = "525";
$revisions[] = "530";
$revisions[] = "562";

if(in_array($revision_p,$revisions)){
$search_query = mysql_query("SELECT * FROM snippets WHERE title LIKE '%$contents%' AND `revision`='$revision_p'");
} else {
$search_query = mysql_query("SELECT * FROM snippets WHERE title LIKE '%$contents%'");
}