SQL quiery

[alienmojo]

this is my first time to use the order by thing in php when i run the script it sayed that it failed

 

here is the quiery im passing in

 

SELECT * FROM estate WHERE price BETWEEN 0 AND 99999999999999 AND baths BETWEEN 0 AND 99999999999999 AND bedrooms BETWEEN 0 AND 99999999999999 AND ORDER BY price

[hvle]

delete the AND before ORDER BY

[alienmojo]

ok thanks that worked! it there a way to make it to where it it sorts by more that just the first number

EX. its saying 9 > 80

[hvle]

use comma after order by:

 

order by price, baths, beds

[alienmojo]

no i only want it to sort by price but say for instance there is a price of 9 and a price of 80 its saying that the 9 is bigger the only thing i can thing of that can cause this maybe is the fact that they are being read in as strings instead of ints

[hvle]

sorry, I misread again.

when you're say ORDER BY price, mysql will sort from small to large (ascending) by default. So will get 9, then 80.

if you like 80, and then 9, use

ORDER BY price DESC

 

[alienmojo]

sorry this is a little hard to put into words i will just show you the output

PRICE

2

250000

250000

250000

7000000

80000

8000000

90000

 

 

basicly its just looking at the first digit from the left and sorting them that way

[Jessica]

Are they varchar instead of int? If so, you need to put the results in an array in PHP and then sort it after converting them to ints.

 

Or fix the column to be an INT

[hvle]

Ok, it look like you stored your price as string (Not recommended).

 

However, here is a work around:

 

...ORDER BY cast(price as unsigned)

 

Althought that can fix problem, it can cause other problem if you don't change the price to an appropriate data type.

[alienmojo]

instead of casting it as unsigned can i put int or decimal

[redarrow]

change the column to a int in the database as your encounter more problams ok.