An error occurred while querying php and mysql statements.

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.