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

Question

1.This is my code search WHERE 1";

    foreach ($terms as $each){
    $i++;

    if ($i == 0)
        $query .= "keywords LIKE '%$each%' "; 
    else
        $query .= "OR keywords LIKE '%$each%' "; 

    }

    //connect
    Mysql_connect ("localhost", "root","");
    Mysql_select_db("search");

    $query = mysql_query($query);
    $numrows = mysql_num_rows($query);
    if ($numrows > 0) {

        While ($row = mysql_fetch_assoc($query))  {
            $id = $row ['id'];
            $tittle = $row ['tittle'];
            $description = $row ['description'];
            $keywords = $row ['keywords'];
            $link = $row ['link'];

            echo "<h2><a href='$link'>$tittle</a></h2>
            $description<br /><br />";
    //disconnect
    mysql_close();

        }   

    }

    Else
        echo "No results found for \"<b>$k</b>\""

?

Check your query, it is wrong, so it returns false. – gbestard Jul 16 '14 at 08:35 — gbestard, Jul 16 '14 at 08:35
Where is your full `$query` content? – Sadikhasan Jul 16 '14 at 08:38 — Sadikhasan, Jul 16 '14 at 08:38

score 0 · Answer 1 · answered Jul 16 '14 at 08:42

Although your question is poorly written and there's missing information the problem could be that $i will never be 0 if you have $i++ before the if statement.

Try to put the $i increment after the if statement.

foreach ($terms as $each){
    if ($i == 0){
        $query .= "keywords LIKE '%$each%' "; 
    }else{
        $query .= "OR keywords LIKE '%$each%' "; 
    }
    $i++
}

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

1 Answers1