PHP/MySQL using ORDER BY with a LIMIT

Question

I created a pagination by roughly following this link:

http://www.awcore.com/dev/1/3/Create-Awesome-PHPMYSQL-Pagination_en#toggle

quite cool. Although I have an issue with my query.

It works fine like this:

require 'includes/function.php';

    $page = (int) (!isset($_GET["page"]) ? 1 : $_GET["page"]);
    $limit = 8;
    $startpoint = ($page * $limit) - $limit;

    $statement = "cars WHERE deleted = 'no'";

$query = mysql_query("SELECT * FROM {$statement} LIMIT {$startpoint}, {$limit} ");

while ($row = mysql_fetch_assoc($query)) {

However when I try to add an ORDER BY to this, like so:

require 'includes/function.php';

    $page = (int) (!isset($_GET["page"]) ? 1 : $_GET["page"]);
    $limit = 8;
    $startpoint = ($page * $limit) - $limit;

    $statement = "cars WHERE deleted = 'no'";

$query = mysql_query("SELECT * FROM {$statement} LIMIT {$startpoint}, {$limit} ORDER BY model DESC");

while ($row = mysql_fetch_assoc($query)) {

or just change the statement like this:

$statement = "rcr_cars WHERE deleted = 'no' ORDER BY model DESC";

I get this error:

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in filepath/myfile.php on line 79.

Line 79 is this line:

 while ($row = mysql_fetch_assoc($query)) {

Can anyone tell me how I am not using the ORDER BY correctly, its got me puzzled. :/

You are not using it correctly, ORDER BY must come before LIMIT statement. Switch them and it should work. — N.B.
– N.B., Commented Feb 5, 2013 at 12:14

Community · Accepted Answer · 2017-05-23 12:24:33Z

3

Try the query as below

$query = mysql_query("SELECT * FROM {$statement} ORDER BY model DESC LIMIT {$startpoint}, {$limit} ");

Where you have gone wrong is LIMIT should come after ORDER BY. Read more

edited May 23, 2017 at 12:24

CommunityBot

11 silver badge

answered Feb 5, 2013 at 12:19

Techie

45.2k45 gold badges164 silver badges248 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Romain · Accepted Answer · 2013-02-05 12:16:38Z

0

Change the query:

$query = mysql_query("SELECT * FROM {$statement} ORDER BY model DESC LIMIT {$startpoint}, {$limit}") ;

answered Feb 5, 2013 at 12:16

Romain

4553 gold badges10 silver badges23 bronze badges

Comments

Aboelseoud · Accepted Answer · 2013-02-05 12:27:03Z

0

$query = mysql_query("SELECT * FROM {$statement} ORDER BY model DESC LIMIT {$startpoint}, {$limit} ");

answered Feb 5, 2013 at 12:27

Aboelseoud

5552 gold badges7 silver badges22 bronze badges

Collectives™ on Stack Overflow

PHP/MySQL using ORDER BY with a LIMIT

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related