Re: [PHP] still problem with getting HIGHest and LOWest VALUES

2001-09-30 Thread Marc van de Geijn
with getting HIGHest and LOWest VALUES > Yes i have it defined as text so what should i put instead ? > > - Wiadomość oryginalna - > Od: News <[EMAIL PROTECTED]> > Do: <[EMAIL PROTECTED]> > Wysłano: 30 września 2001 16:47 > Temat: Re: [PHP] still problem wi

RE: [PHP] still problem with getting HIGHest and LOWest VALUES

2001-09-30 Thread Don Read
On 30-Sep-2001 Teqila MAN wrote: > The table has values : > > id - price > 1 - 15 > 2 - 24000 > 3 - 65000 > 4 - 20 > > > When i want to sort it > > $x = mysql_query("SELECT * FROM $dealer_tabela ORDER BY cena"); >while ($row = mysql_fetch_array($x)) >{ >

Re: [PHP] still problem with getting HIGHest and LOWest VALUES

2001-09-30 Thread News
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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: 30 September 2001 16:22 Subject: [PHP] still problem with getting