Simple Query help needed

[elentz]

I have a simple update query that I want to run from a php script.  The query will work just fine from PHPMyadmin.  But it won't update from the code I put into the script.  What have I got wrong here?

// connect to db
$conn = mysql_connect('localhost','couniq','9AXMY') or trigger_error("SQL", E_USER_ERROR);
$db = mysql_select_db('communiq_vtcrm1',$conn) or trigger_error("SQL", E_USER_ERROR);
//Update Query to do the math for the extended prices of items sold
$sql = "Update vtiger_inventoryproductrel SET extlistprice = quantity * listprice";
      $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
mysql_close();

 

Thanks

[Lyleyboy]

Do you get any error messages?

[elentz]

Nope

[PFMaBiSmAd]

What does adding the following two lines immediately after the first opening <?php tag give -

ini_set("display_errors", "1");
error_reporting(E_ALL);