Hello, I have a problem adding information from a form to the database, the big thing is when i press "submit" the page refresh, form action= add.php then nothing happens, no errors, no adding into the database ? ...
Here is part of the code ... I think most be an error with the variables "'.$.'" but dunno what ?
if ($Submit == "Submit") {
$sql = 'INSERT INTO Inventory A ( Item Name, SKU, Short Description, Product Group, Category, Product Price, Dealer Price, Small Picture, Large Picture, Detailed Description, Weight, Special, Taxable, View, Add To Cart )
VALUES ( "'.$ItemName.'" , "'.$SKU.'" , "'.$ShortDescription.'" , "'.$ProductGroup.'" , "'.$Category.'" , "'.$ProductPrice.'" , "'.$DealerPrice.'" , "'.$SPic.'" , "'.$LPic.'" , "'.$DetailedDescription.'" , "'.$Weight.'" , "'.$Special.'" , "'.$Taxable.'" , "'.$View.'" , "'.$Add.'" ) ';
if (@mysql_query($sql)) {
echo( "<p>Your Item has been
added.</p>");
} else {
echo( "<p>Error adding submitted Item:<br><br> " .
mysql_error() . "</p>");
}
}
