can anyone see anything wrong with this code?
when i update, it updates everything with blank records.
i have used a pretty much simmilar script for updating stock and it works fine.
thanx guys.
Code: Select all
<?php
$db = mysql_pconnect('**', '**', '**') or die ("Could not connect to database");
mysql_select_db('models') or die ("Could not select database!");
if ($_SERVER['REQUEST_METHOD'] == "POST")
{
$ud_C_First = stripslashes($_POST["ud_C_First"]);
$ud_C_Last = stripslashes($_POST["ud_C_Last"]);
$ud_C_Email = stripslashes($_POST["ud_C_Email"]);
$ud_C_Phone = stripslashes($_POST["ud_C_Phone"]);
$ud_C_Address1 = stripslashes($_POST["ud_C_Address1"]);
$ud_C_Address2 = stripslashes($_POST["ud_C_Address2"]);
$ud_C_City = stripslashes($_POST["ud_C_City"]);
$ud_C_Country = stripslashes($_POST["ud_C_Country"]);
$query = "UPDATE customer SET C_First='$ud_C_First',C_Last='$ud_C_Last',C_Email='$ud_C_Email',C_Phone='$ud_C_Phone',C_Address1='$ud_C_Address1',C_Address2='$ud_C_Address2',C_Country='$ud_C_Country',C_City='$ud_C_City' WHERE C_ID='$C_ID'";
#execute SQL statement
$result = mysql_query($query, $db) or die (mysql_error()."<br />Couldn't execute query: $query");
##mysql_query($query);
print "<br><b>details updated</b><br><br>";
echo"$C_ID";
echo"$ud_C_First";
echo"$ud_C_Last";
echo"$ud_C_Email";
echo"$ud_C_Phone";
}
?>