[RESOLVED] Simple Database Query Help

[middleman666]

hey people,

bit new to database work so bare with me.
i have a database which has a table which has a number of fields. what i would like to do is display the latest entries on a front page, but I want know how to display the latest entry from a certain category which is defined in the field category.

sorry, i dont know if that makes sense to anyone.

all i have a the moment is:
mysql_query("SELECT * FROM myTable ORDER BY id DESC")

could I simple do something like?:
mysql_query("SELECT * FROM myTable ORDER BY category DESC LIMIT 1")

edit: sorry just relised that wouldnt work... but i need something like that where you can define the category field.

thanks for any help.

[middleman666]

got it..

mysql_query("SELECT * FROM myTable ORDER BY category = '1' DESC LIMIT 1")