CODEWITHSUNDEEP
phpmysql
PHPSrike
PHPSrike

Reputation: 33

How Do I Order This Query?

I want to order this query descending by ID.

I get the error mysql_fetch_array() expects parameter 1

$checkquery = "SELECT COUNT(message), user, date_time FROM messages";           
$collctmsg = mysql_query($checkquery, $db_connect);
$no_rows = mysql_fetch_row($collctmsg);
$numrows = $no_rows[0];
$rows_per_page = 5;
$lastpage = ceil($numrows/$rows_per_page);
$pageno = (int)$pageno;
if ($pageno > $lastpage) {
   $pageno < $lastpage;
} // if
if ($pageno < 1) {
   $pageno = 1;
} // if
$limit = 'LIMIT ' .($pageno - 1) * $rows_per_page .',' .$rows_per_page;

$messageshow = "SELECT message, user, date_time FROM messages {$limit}, ORDER BY id DESC";
$message_execution = mysql_query($messageshow, $db_connect);

Upvotes: 0

Views: 69

Answers (3)

divya
divya

Reputation: 19

Update your query. After limit No need to put coma:

$messageshow = "SELECT message, user, date_time FROM messages {$limit} ORDER BY id DESC";

Upvotes: 1

Mark Baker
Mark Baker

Reputation: 212412

Limit last, and no comma between your limit clause and you order by clause

SELECT message, user, date_time FROM messages ORDER BY id DESC {$limit}

Upvotes: 1

Jeremy Harris
Jeremy Harris

Reputation: 24549

This is done using the ORDER BY clause:

SELECT message, user, date_time FROM messages ORDER BY id DESC

Upvotes: 2

Related Questions