MySQL Forums
Forum List  »  PHP

Re: Pagination Group By - limit
Posted by: Peter Brawley
Date: January 25, 2018 04:15PM

> SELECT * FROM table_name WHERE level = '3' GROUP BY state

That will return one arbitrary value row per state with level=3. Probably not what you had in mind. read about only_full_group_by in the manual.

> ORDER BY state ASC limit $ start, $ quantity

Lose the space between $ and the following name. (The script doesn't set these values.)

Options: ReplyQuote

Written By
January 22, 2018 09:45PM
Re: Pagination Group By - limit
January 25, 2018 04:15PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.