passing to a variable

[assonitis]

My brain has stuck....

$query="SELECT rate FROM discounts WHERE username='$username' ";
$result=mysql_query($query);

i have a table with 3 columns,
'username', 'afm', and 'rate'

how can I pass the result to a variable, so if the rate is 30 the variable to return me 30?

thanks guys

[Anon]

Use the mysql_fetch_* functions.

Diego