SELECT * FROM os WHERE size > 15 LIMIT 10 OFFSET 0 Doesn't work
by TrekJunky from LinuxQuestions.org on (#5KVSJ)
Code:SELECT * FROM os WHERE size > 15;
60 Total OSes 0 Page Next 10 Records
SELECT * FROM os WHERE size > 15
SELECT * FROM os WHERE size > 15 LIMIT 10 OFFSET 0;
Warning: mysqli_num_rows expects parameter 1 to be mysqli_result, bool given in /srv/www/htdocs/index5.php on line 983
Call Stack
Time Memory Function Location
1 0.0000 360320 main .../index5.php:0
2 0.0010 496096 mysqli_num_rows( $result = FALSE ) .../index5.php:983"SELECT * FROM os WHERE size > 15" works fine
60 Total OSes 0 Page Next 10 Records
SELECT * FROM os WHERE size > 15
SELECT * FROM os WHERE size > 15 LIMIT 10 OFFSET 0;
Warning: mysqli_num_rows expects parameter 1 to be mysqli_result, bool given in /srv/www/htdocs/index5.php on line 983
Call Stack
Time Memory Function Location
1 0.0000 360320 main .../index5.php:0
2 0.0010 496096 mysqli_num_rows( $result = FALSE ) .../index5.php:983"SELECT * FROM os WHERE size > 15" works fine