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: Marc van de Geijn (marc <email protected>)
Date: 09/30/01

Define the column as an INT or BIGINT. That should solve the problem.

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

> Yes i have it defined as text.... so what should i put instead ?
>
> ----- Wiadomość oryginalna -----
> Od: News <news <email protected>>
> Do: <php-general <email protected>>
> Wysłano: 30 września 2001 16:47
> Temat: Re: [PHP] still problem with getting HIGHest and LOWest VALUES
>
>
> > 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>
> >
> >
>
>
> --
> 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>