simple mysql select question

[safra]

Hi,

I have a column with numbers. How do I select the row with the lowest number and return this number?

I guess I have to order the table first but I cannot find out how the select the first row of the ordered table.

Thanks

[GoSharks]

this might help (the min() func)

[RedDragon]

$query = "SELECT * FROM table ORDER BY id ASC LIMIT 0,1";

[safra]

Thanks, works great!