PHP - Moved: Mysql Order By?

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=328623.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=321790.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=355706.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=318036.0

Lets say I have this query:

$sql = mysql_query("SELECT * FROM Member ORDER BY posts DESC LIMIT 10");
while ($get = mysql_fetch_array($sql)){

$row .= $get['id'];
$posts .= $get['posts'];

echo "$row - $posts<br />";

}

Lets say I have two of rows, with posts fields of 84 and 803. When it displays it, it grabs the 84 row first, when I want the bigger number 803 first. Is there a way to fix this?

I'm currently trying to grab data from my database for my chatbox, which when displayed, displays in an ascending order, when I call it to descend, it shows the messages ONCE in descending order, then just repeats but in random order..

Code: [Select]
$sql = "SELECT * FROM `message` WHERE `chat_id` = 1 AND `message_id` > $last ORDER BY `message_id` DESC";
Database:
message_id | name
1                   RSX
2                   RSX
3                   RSX
4                   RSX

Code: [Select]
RSX: 4
RSX: 3
RSX: 2
RSX: 1
RSX: 4
RSX: 3
RSX: 2
RSX: 4
RSX: 3
RSX: 4

It is ordering it correctly, just repeats, I'm using Ajax, could that be the problem, or is it within the PHP code?

Edit:
I read it wrong, it displays as shown under "output".

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=328735.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=319167.0

This topic's house has been seized by the bank and it now lives in MySQL Help until it can get back on its feet.

http://www.phpfreaks.com/forums/index.php?topic=358035.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=326563.0

Hello,

I would like to order by date that contains day and month, like this: 14-3
Is this possible?

Quote

$sql = mysql_query("SELECT * FROM date WHERE online='1'");

hello all.
I have a list of records, which each have a comment button, just like any forum does. when I click on the comment button it brings up the current record at the top, and a blank form, to which you enter in information.

When I submit this information, I want it to show up on the main page as a child of the parent record. I want it similar to the example I've shown below:
Code: [Select]
id name         dob           address              email                  username
1  john smith   10/11/1986    124 Peermont Drive   john.smith@yahoo.com   john smith1
  >>  2   Harry        15/12/1985     98 The Roundhay     harry@gmail.com        harry23
    >>>  3  jhk          08/11/1976     65 dfgdfg           gfdfg@ yahoo.com       jhk345
4  john smith   10/11/1986    124 Peermont Drive   john.smith@yahoo.com   john smith1
     >> 5 Harry        15/12/1985     98 The Roundhay     harry@gmail.com        harry23
        >>>> 6  jhk          08/11/1976     65 dfgdfg           gfdfg@ yahoo.com       jhk345

I've been stuck on this for hours, and I haven't got anywhere. Any ideas?

ok so i want to order by high to low on the field price but i don't know how to do this.

i can order low to high by using ORDER BY  `Price` ASC

but how can i order high to low?

When you make a mysql query the results are always returned with the first being the first entry in the database.  I was wondering if there is a way to make it so that the last entry is returned first and so on?  Thanks for any help. 

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=332593.0