[RESOLVED] select lowest number?

I just want to select the lowest number in the table..

SELECT * FROM table_name ORDER BY total LIMIT 1

in my table 'total' it always picks the highest number

even if I use ASC or DESC it always ends up picking the highest number.

Is there an easy way to solve this?

you can use

SELECT MIN(col_name) AS col_alias FROM table_name

then

$var = $row['col_alias']

I need to SELECT * FROM table_name...

is there a way to do this in one query?

You want to select all or the lowest value, you have to decide ...

thanks for replies, I fixed it anyway, the original query was correct, just hadn't set the field to int :rolleyes:

i had man flu at the time 😃