how to fetch data from mysql?

hi i have tried putting this in my field,

<?php
$amount = db_result(db_query('SELECT MAX(amount) FROM {table})); 
echo $amount
?>

But it doesnt display anything in the field.

Is this supposed to happen?

how can I fetch data from my database?

Thanks for any help