An error occurred while querying php and mysql statements. this is an SQL statement. only 25 records can be queried. see the running result.
Please tell me why
Reply to discussion (solution)
Limit 25, 50
Indicates that 50 rows are output starting from the first row in the result.
The LIMIT clause can be used to LIMIT the number of rows returned by the SELECT statement. LIMIT takes one or two numeric independent variables. the independent variables must be non-negative integer constants (except when prepared statements are used ).
When two independent variables are used, the first independent variable specifies the offset of the first row returned, and the second independent variable specifies the maximum number of returned rows. The offset of the initial row is 0 (not 1)
The LIMIT clause can be used to LIMIT the number of rows returned by the SELECT statement. LIMIT takes one or two numeric independent variables. the independent variables must be non-negative integer constants (except when prepared statements are used ).
When two independent variables are used, the first independent variable specifies the offset of the first row returned, and the second independent variable specifies the maximum number of returned rows. The offset of the initial row is 0 (not 1)
"Select * from image where classify = 'beauty' order by id desc limit 25, 25"; that means that 25 records are obtained from 25. Right ~
Yes, that's right.