mysql+php query

["Exiang" <allentan@pd.jaring.my>]

Hi, i hav a problem query a data value from my database
every setting is fine. the database is working too.just i dunno how to do it with php

let say i hav a username and a password in my database
i wanto query the password with given username

$SQL = "SELECT `password` FROM `table` WHERE `username` = '$user';";
$result = mysql_db_query($db,"$SQL",$cid);


but the result i hav is a Resource id #4 but not the value of password that i wan.
Pls help me..thanx.