Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2001092

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

I'm not much into PHP, but looking at it from SQL I guess you have defined
the price column as a string? Make it an integer...?

Marc

----- Original Message -----
From: "Teqila MAN" <teqilaman <email protected>>
To: <php-general <email protected>>
Sent: 30 September 2001 16:22
Subject: [PHP] still problem with getting HIGHest and LOWest VALUES

> 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>
> 

-- 
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>