Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2001092

[PHP] Re: still problem with getting HIGHest and LOWest VALUES From: Hidulf (hidulf <email protected>)
Date: 09/30/01

try this

$x = mysql_query("SELECT * FROM $dealer_tabela ORDER BY cena");
$row = mysql_fetch_array($x);

natsort($row);

print 'id - price<br />\n';
while (list ($key, $val) = each ($row)) {
    print $key .' - ' .$val .'<br />\n';
} 

--
Hidulf
http://www.hidulf.com
"Teqila Man" <teqilaman <email protected>> wrote in message
news:001801c149bb$63026d60$0100007f <email protected>
> 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.
>

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>