Newb Question?

How can I extract the value of customerID to a variable from the result of the following query?

$result = @mysql_query("SELECT customerID FROM customers WHERE dirNAME = '.$jclogin.'");

Thanks


while ($array = mysql_fetch_array ($result)) {

$customerID = $array['customerID'];

print ($customerID . "<br />");

}