mysql output sort order

Question

I am using a PHP / MySQL pagination script which works fine, however I have trouble sorting the output accordingly.

Here parts of my script:

        $link=mysql_connect("localhost","x","x");
        mysql_select_db("x",$link);
        $q="select count(*) \"total\"  from entries";
        $ros=mysql_query($q,$link);
        $row=(mysql_fetch_array($ros));
        $total=$row['total'];
        $dis=3;
        $total_page=ceil($total/$dis);
        $page_cur=(isset($_GET['page']))?$_GET['page']:1;
        $k=($page_cur-1)*$dis;

        $q="select * from entries limit $k,$dis";
        $ros=mysql_query($q,$link);
        while($row=mysql_fetch_array($ros))
        {

I've tried to change the line

    $q="select count(*) \"total\"  from entries";

to

    $q="select count(*) \"total\"  from entries id DESC";

however it does not seem to be working correctly.

Anyone has an idea how I can get this fixed and have the items sorted by ID?

Some expert help would be greatly appreciated - thank you very much.

Please find the original script I have in place here: http://allitstuff.com/php-mysql-pagination-script-download/

Did you mean: $q="select * from entries limit $k,$dis ORDER BY id DESC;" ? — cyberwombat
– cyberwombat, Commented Jan 25, 2014 at 7:24

Linga · Accepted Answer · 2014-01-25 07:40:19Z

1

The coury

select count(*) \"total\"  from entries

only returns the count. You can get only the total number of rows.

If you want to retrieve data please change your query.

If you want to manipulate with the count only, then try

$row=mysql_fetch_row($ros);
$total=$row[0];

Edit:

The OP want to sort the entries in a reverse order. So try

select column_name from entries order by column_name desc;

edited Jan 25, 2014 at 7:40

answered Jan 25, 2014 at 7:23

Linga

10.6k10 gold badges57 silver badges109 bronze badges

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

4 Comments

David Over a year ago

thank you very much for your comment. how exactly would I need to change this? As mentioned it's a pagination script and works fine, however there seems to be no sort order in place.

David Over a year ago

Basically what I need is this script to work and just sort the entries in a reverse order (as they currently are) - I have updated the first post and added a link to the original script

Linga Over a year ago

@David select column_name from entries order by column_name desc;

David Over a year ago

Thank you very much for your input - as soon though as I apply any changes to the $q="select count(*) \"total\" from entries"; part the pagination stops working

Satish Sharma · Accepted Answer · 2014-01-25 07:24:12Z

0

try it

$q="select count(*) as total  from entries ORDER BY id DESC;";

answered Jan 25, 2014 at 7:24

Satish Sharma

9,6356 gold badges31 silver badges52 bronze badges

1 Comment

Patrick Evans Over a year ago

still wouldnt matter as its just doing a count

KethanKumar · Accepted Answer · 2014-01-25 07:26:40Z

0

Try this:

count(*) returns only count. FOR EXAMPLE

SELECT column_name1,column_name2,count(*)
FROM table_name
ORDER BY column_name1,column_name2 ASC|DESC;

answered Jan 25, 2014 at 7:26

KethanKumar

7265 silver badges17 bronze badges

Collectives™ on Stack Overflow

mysql output sort order

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related