PHP Not inserting into Database :(?

B

Ben

New member
Not sure what is going on. The variables are all being passed correctly to the script but nothing is going into the database. The authentication works because i have other scripts working but this isn't Thanks!

<?php
include 'config.phps';
include 'opendb.phps';

$vOrder_ID = $_POST["sOrder_ID"];
$vDist_ID = $_POST["sID"];
$vTotal = $_POST["sTotal"];
$vShipping = $_POST["sShipping"];
$vProducts = $_POST["sOrdered_Prod"];
$vQuantities = $_POST["sOrdered_Q"];
$vPrices = $_POST["sOrdered_P"];
$vComments = $_POST["sComments"];

mysql_query("INSERT INTO Dist_Orders (Order_ID, ID, Total, Shipping, Ordered_Q, Ordered_P, Ordered_Prod, Date, Comments) VALUES (" . $vOrder_ID . ", " . $vDist_ID . ", " . $vTotal . ", '" . $vShipping . "', '" . $vQuantities . "', '" . $vPrices . "', '" . $vProducts . "', NOW(), '" . $vComments . "')");
if (!mysql_query($sql,$conn))
{
die('Error: ' . mysql_error());
}

include 'closedb.phps';
?>
 
Back
Top