$query=mysql_query("SELECT COUNT(*) as counter 
                FROM $table->book_list
                WHERE $table->book_list.class_id=$class_id");        while($result=mysql_fetch_array($query)){
                $counter=$result['counter'];

解决方案 »

  1.   

    $book_name=$result['book_name'];
                    $book_author=$result['author'];
                    $book_contents=$result['contents'];
                    $book_id=$result['book_id'];
        但是我这些就不能用了
      

  2.   

    $query=mysql_query("SELECT $table->book_list.book_name,$table->book_list.author,$table->book_list.contents,$table->book_list.book_id
                    FROM $table->book_list
                    WHERE $table->book_list.class_id=$class_id LIMIT 20");
    $nums=mysql_num_rows($query);//放在这里就行了
            while($result=mysql_fetch_array($query)){
                    $book_name=$result['book_name'];
                    $book_author=$result['author'];
                    $book_contents=$result['contents'];
                    $book_id=$result['book_id'];
      

  3.   

    改成WHERE $table->book_list.class_id=$class_id LIMIT $offset,20");后Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in listbook.php on line 25Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in listbook.php on line 26