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 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" <[EMAIL PROTECTED]> > To: <[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: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]