Newb Question?

[biscutty]

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

 

:?

 

PHP:

--------------------------------------------------------------------------------

 

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

 

--------------------------------------------------------------------------------

 

 

Thanks

?>[/code]

[DylanBlitz]

[php:1:5c656c3b10]

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

if (!$result) { echo mysql_errno().\": \".mysql_error().\"n\"; exit; }

 

$custdata = mysql_fetch_array($result);

$customerID = $custdata[customerID];

[/php:1:5c656c3b10]