Hi people
im having problems with the following script. When the submit button is pressed on an HTML form, it should update the database using this script. What is wrong?
Thanx
Jonathan
============coding=========
<?php
$dbcnx = @mysql_connect("localhost",
"***", "***");
if (!$dbcnx) {
echo( "<P>Unable to connect to the " .
"database server at this time.</P>" );
exit();
}
if (! @mysql_select_db("catalog") ) {
echo( "<P>Unable to locate the " .
"database at this time.</P>" );
exit();
}
$result = mysql_query("SELECT make, model, Derivative, Product, Description, price FROM hsc_products where
product = '$productid'");
$query = mysql_query("UPDATE hsc_products SET
make='$make',
model='$model',
Derivative='$Derivative',
Product='$Product',
Description='$Description',
price='$Price',
Product='$Product'
WHERE Product = '$Product2'");
print "Done";
?>
========= end======
