[Resolved] ORDER BY not working?

dbdamnedman

This is the simple snip-it I am using:

<?php
$query = @mysql_query("SELECT * FROM se_accounts ORDER BY equity DESC");
$i=0;
while ($row=@mysql_fetch_array($query)) {
  if ($row[other] !== "Y") {
    $i++;
  }
echo "<tr>
<td align=\"center\">";
  if ($row[other] == "Y") {
    echo "<font class=\"redtext\">*</font>";
  } else {
    echo $i;
  }
echo "</td>
<td align=\"center\">
{$row[company]}
</td>
<td align=\"center\">";
echo "US\$" . formatNumber($row[equity]);
echo "</td>
</tr>";
}
?>

Here is an example of the output:

Position  Company Name  Equity  

1 Name1  US$99,975.00 
* Name2  US$99,975.00 
2 Name3  US$111,612.97 
3 Name4  US$100,000.00 
4 Name5  US$100,000.00 
5 Name6  US$100,000.00

It SHOULD be:

Position  Company Name  Equity  

1 Name3  US$111,612.97 
2 Name4  US$100,000.00 
3 Name5  US$100,000.00 
4 Name6  US$100,000.00 
5 Name1  US$99,975.00 
* Name2  US$99,975.00

Does anyone know what's going wrong? Any help is very much appriciated.

Thank you in advance.

LordShryku

What type of field is that?

dbdamnedman

"equity" is VARCHAR(20) NOT NULL. Do I have to set it to INT?

LordShryku

If you want it to sort like a number, yes. With varchar, it's going to treat it as a regular alphanumeric string.

The other option to this would be to put the results in an array and use php's [man]natsort[/man]

dbdamnedman

Thanks! 🙂