selecting last updated value from database !!

[electronish]

I want to get the last "created" value from the table row which has  student id 7646 and class 03

this aint working .. !!
[code]
$query = "SELECT max(created) FROM `file_transactions` WHERE student_roll = '7646' and class = '03'";



[/code]

[Orio]

Try:
[code]SELECT created FROM `file_transactions` WHERE student_roll = '7646' and class = '03' ORDER BY created DESC LIMIT 1[/code]

Orio.