Allora forse è qui che fa l'update
require 'secure.php';
require 'global.php';
require 'config/config.php';
// process and store data
if($edit) {
// check to see if the stock number entered already exists in db
$link = mysql_connect($dbhost, $dbuser, $dbpass);
if(mysql_num_rows($result)) {
echo "<script language='JavaScript'> alert('The stock number you entered already exists in the database.'); </script>";
} else {
// make input query friendly
foreach($_POST as $key => $value) {
$_POST[$key] = addslashes($value);
}
// add listing to database
$time = time();
$link = mysql_connect($dbhost, $dbuser, $dbpass);
$query = "UPDATE $dbvin SET
updated='$time',
stock='$_POST[stock]',
vin='$_POST[vin]',
year='$_POST[year]',
make='$_POST[make]',
model='$_POST[model]',
condition='$_POST[condition]',
category='$_POST[category]',
mileage='$_POST[mileage]',
price='$_POST[price]',
exterior='$_POST[exterior]',
interior='$_POST[interior]',
body='$_POST[body]',
doors='$_POST[doors]',
engine='$_POST[engine]',
fuel='$_POST[fuel]',
trans='$_POST[trans]',
stereo='$_POST[stereo]',
comments='$_POST[comments]'
WHERE ccode='$ccode'";
mysql_db_query($dbname, $query, $link);
mysql_close($link);
echo "<script language='JavaScript'> window.location='summary.php?ccode=$ccode'; </script>";
echo "You updated a vehicle";
exit();
}
} else {
$link = mysql_connect($dbhost, $dbuser, $dbpass);
$query = "SELECT * FROM $dbvin WHERE ccode='$ccode'";
$result = mysql_db_query($dbname, $query, $link);
$data = mysql_fetch_array($result);
mysql_close($link);
// strip any added slashes
foreach($data as $key => $item) {
$data[$key] = stripslashes($item);
}
}
?>