still problem with getting HIGHest and LOWest VALUES
| From: | Teqila MAN | Date: | Sun, 30 Sep 2001 14:22:50 +0000 |
| Subject: | still problem with getting HIGHest and LOWest VALUES | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-69359@lists.php.net to get a copy of this message | ||
The table has values :
id - price
1 - 150000
2 - 24000
3 - 65000
4 - 200000
When i want to sort it
$x = mysql_query("SELECT * FROM $dealer_tabela ORDER BY cena");
while ($row = mysql_fetch_array($x))
{
$id=$row["id"];
$price=$row["price"];
print("$price<br>\n");
}
It returns me values :
150000
200000
24000
65000
What is false! It sorts this by getting first values ? How to fix it ?
Thanks for your help
tm.