Add Operation Failed ");
}
$query = "SELECT * FROM Product WHERE ProductID='$pid'";
$result = mysql_query($query);
} else {
if ($add_or_del == "del") {
// deleting a product
echo " Product does not already exist - can't delete $pid ";
} else {
if ($add_or_del == "quantity_change") {
// quantity change of a product
} else {
die("not sure what you wanted! try here");
}
}
}
} else {
// product does exist
if ($add_or_del == "del") {
// deleting a product
echo "Product exists - deleting $pid $desc";
$query = "DELETE FROM Product WHERE ProductID='$pid'";
$result = mysql_query($query);
if ($result < 1) {
echo "
".mysql_errno().": ".mysql_error()."
";
die("
Add Operation Failed "); } $query = "SELECT * FROM Product WHERE ProductID='$pid'"; $result = mysql_query($query); } else { if ($add_or_del == "add") { // adding a product echo " Product already exists - $pid $desc "; } else { if ($add_or_del == "quantity_change") { // quantity change of a product echo "Changing the quantity of $pid $desc by $quantity_change when we implement it ..."; } else { die("not sure what you wanted! try here"); } } } } ?>
| Product CODE | Product Details | Cost | Markup | Sell Price | Quantity |
| |||||
| |||||