Problem with PHP and MySQL, How can I fix this code? It doesn't work. Please help.?

[markjaysontimbol]

<?php
if(isset($_POST['submit'])){
$myCode = $_GET['productCode'];

$barcode = $_POST['barcode'];
$name = $_POST['productName'];
$cat = $_POST['category'];
$sup = $_POST['supplier'];
$price = $_POST['price'];
$mark = $_POST['markup'];
$srp = $_POST['srp'];
$optimum = $_POST['optimumLevel'];
$min = $_POST['minimumLevel'];
$crit = $_POST['criticalLevel'];

$query = "UPDATE tbl_product
SET
productName = '$name',
barcode = '$barcode',
price = '$price',
markup = '$mark',
srp = '$srp',
optimumLevel = '$optimum',
minimumLevel = '$min',
criticalLevel = '$crit',
supplierCode = '$sup',
categoryCode = '$cat'
WHERE
productCode = '" . $row_rsProduct['productCode'] . "'";

$query2 = mysql_query($query);
if($query2) {
header("locationroduct.php");
exit();
}
}