Trying to update Acess Db using Php and ODBC, I am somehow not connecting, any Ideas?

J

Jason

New member
1) I created a USER DNS

Please see the the PHP code below, Much appreciated

$conn=odbc_connect('PBG_update','','pbg001');
if (!$conn)
{exit("Connection Failed: " . $conn);}
$sql="UPDATE orders_new SET Client_Name='$Client_Name',Balance_Out='$Balance_Out',Alteration_Instructions='$Alteration_Instructions', First_Fitting_Date='$First_Fitting_Date',Final_Fitting_Date='$Final_Fitting_Date',Collection_Date='$Collection_Date',Status='$Status',Ready_by='$Ready_by',Collection_Date='$Collection_Date',Payment_Reminder='$Payment_Reminder' WHERE Invoice_Number='$Invoice_Number'";
$rs=odbc_exec($conn,$sql)
or die ("could not find database");
if (!$rs)
{
$msg = "$Invoice_Number, has been updated";
}
odbc_close($conn);
?>
 
Back
Top