mySQL on duplicate key multiple update
===

im trying to create a simple SQL INSERT otherwise UPDATE statement but to be honest I don't know what im doing

here is my function so far

    function addInventoryBook($isbn, $sku, $price, $quantity, $condition, $dateOpened){
       $q = "INSERT INTO ".TBL_INVENTORY." VALUES('$isbn', '$sku', $price, 
       $quantity, '$condition', $dateOpened)
       ON DUPLICATE KEY UPDATE VALUES('$isbn', '$sku', $price, $quantity, 
       '$condition', $dateOpened)";		
    
       return mysql_query($q, $this->connection);			
    }




a previous function which seemed that update the price field was working

    function addInventoryBook($isbn, $sku, $price, $quantity, $condition, $dateOpened){
       $q = "INSERT INTO ".TBL_INVENTORY." VALUES('$isbn', '$sku', $price, 
       $quantity, '$condition', $dateOpened)
       ON DUPLICATE KEY UPDATE SET price = $price";		
        
       return mysql_query($q, $this->connection);			
    }