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

[subbu_1]

if query passed in search box by selecting the category as fiction or whatever it may be, it should search in both title and author, if value got in title then no need to search in author, if not need to search in author,

    $search = $_POST['searchvalue']; //assume search value as xyz
    $name = $_POST['name'];// assume category as fiction

 $construct = "SELECT * FROM books WHERE category = $name  AND (title LIKE '%$search%' or author LIKE '%$search%')";
     $run = mysql_query($construct);
     $foundnum = mysql_num_rows($run);// I am getting error here

please anyone help me
database table is given below

[cereal]

It happens because the query returns FALSE instead of returning a result set, there is an error in your query, try to add the quotes around $name:

... category = '$name' ...

But you should really switch to prepared statements:

• http://php.net/mysqlinfo.api.choosing
• http://php.net/manual/en/pdo.prepared-statements.php
• http://php.net/manual/en/mysqli.quickstart.prepared-statements.php

[subbu_1]

Thank you very much it worked...