Trouble sorting numbers in a mysql database *Resolved*
Posted 22 June 2006 - 02:42 PM
i want to be able to sort the database by price, high to low or low to high.
$query = "SELECT * FROM $table order by price asc LIMIT $limitvalue, $limit";
$limitvalue and $limit are pagination variables which work okay
the table gets sorted by price okay but i get:
you can see whats happening, wbut why? and how can i fix it display the correct ascending order.
Posted 22 June 2006 - 02:58 PM
Posted 22 June 2006 - 03:49 PM
i've been waving my fist at the computer Basil Fawlty style...and swearing..
well, its a good job you is a moderators and i aint.
edit: Just tried it, it worked....prob resolved!
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users