Why does this keep returning PHP ERROR Warning: mysql_num_rows() expects parameter 1 to be resource

Question

I have tryed to solve this but it has me stuck. any ideas help much appreciated. The book id is getting send to the url. url looks like /bookinfo.php?bookid=1

if(isset($_GET['bookid'])){
    $id = preg_replace('#[^0-9]#i','', $_GET['bookid']);
    $sql = "SELECT DISTINCT bk.title AS Title, bk.year AS Year, bk.publisher AS Publisher, aut.authorname AS Author cat.category AS Category
         FROM book bk 

         JOIN book_category bk_cat 
         ON bk_cat.book_id = bk.bookid

         JOIN categories cat 
         ON cat.id = bk_cat.category_id

         JOIN books_authors bk_aut 
         ON bk_aut.book_id = bk.bookid

         JOIN authors aut
         ON aut.id = bk_aut.author_id

         WHERE bk.bookid='$id' LIMIT 1";

    $productCount = mysql_num_rows($sql);
    if($productCount>0){
        while($row =mysql_fetch_array($sql)){
            $bookTitle = $row["Title"];
            $bookYear = $row["Year"];
            $bookPublisher = $row["Publisher"];
            $bookcopies = $row["copies"];
            $bookAvailableforreserve = $row["availableforreserve"];
            $bookDescription = $row["description"];
            $bookAuthor = $row["Author"];
            $bookCategory = $row["Category"];


        }
    }

?>

possible duplicate of mysql_fetch_array() expects parameter 1 to be resource, boolean given in select — Bojangles
– Bojangles, Commented Mar 18, 2014 at 22:10

Shay Young · Accepted Answer · 2014-03-18 22:49:16Z

1

Got it the problem was being caused by a miss , before the start of cat.category AS Category

Thanks

answered Mar 18, 2014 at 22:49

Shay Young

1973 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Fabio · Accepted Answer · 2014-03-18 22:11:22Z

0

You didn't execute your query that's why mysql_num_row() give you the error

$sql = mysql_query("SELECT DISTINCT bk.title AS Title, bk.year AS Year, bk.publisher AS Publisher, aut.authorname AS Author cat.category AS Category
     FROM book bk 

     JOIN book_category bk_cat 
     ON bk_cat.book_id = bk.bookid

     JOIN categories cat 
     ON cat.id = bk_cat.category_id

     JOIN books_authors bk_aut 
     ON bk_aut.book_id = bk.bookid

     JOIN authors aut
     ON aut.id = bk_aut.author_id

     WHERE bk.bookid='$id' LIMIT 1");

$productCount = mysql_num_rows($sql);

answered Mar 18, 2014 at 22:11

Fabio

23.5k12 gold badges57 silver badges66 bronze badges

1 Comment

Shay Young Over a year ago

hey fabio thank for helping, just tried that still same result :( anything else you can see

Alfonse · Accepted Answer · 2014-03-18 23:15:55Z

0

You need to do a mysql_query() on your select string in order to do use the mysql_num_rows() function.

$sql = "SELECT DISTINCT bk.title AS Title, bk.year AS Year, bk.publisher AS Publisher, aut.authorname AS Author cat.category AS Category
 FROM book bk 

 JOIN book_category bk_cat 
 ON bk_cat.book_id = bk.bookid

 JOIN categories cat 
 ON cat.id = bk_cat.category_id

 JOIN books_authors bk_aut 
 ON bk_aut.book_id = bk.bookid

 JOIN authors aut
 ON aut.id = bk_aut.author_id

 WHERE bk.bookid='$id' LIMIT 1";

$sql_query = mysql_query($sql);

$productCount = mysql_num_rows($sql_query);

edited Mar 18, 2014 at 23:15

answered Mar 18, 2014 at 22:40

Alfonse

7941 gold badge6 silver badges9 bronze badges

Collectives™ on Stack Overflow

Why does this keep returning PHP ERROR Warning: mysql_num_rows() expects parameter 1 to be resource

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related