CODEWITHSUNDEEP
phpmysql
user3395352
user3395352

Reputation: 50

My mysql update query isnt working

for some reason, I can't get this to work.

Thanks in advance, a secnod eye might help!

$sql3 = "SELECT order_id FROM orders WHERE order_code = '$order_code'";
$result3 = $conn->query($sql3) or exit("Error code ({$conn->errno}): {$conn->error}");

$row = mysqli_fetch_assoc($result3);
$order_id = $row['order_id'];       

$deliv_date = date('Y-m-d');

$sql = "UPDATE orders SET deliv_date = $deliv_date
                WHERE order_id = $order_id";
$result = $conn->query($sql) or exit("Error code ({$conn->errno}): {$conn->error}");

$sql1 = "INSERT INTO invoice VALUES (0,'$order_code','$deliv_date','','$order_id')";

$result1 = $conn->query($sql1) or exit("Error code ({$conn->errno}): {$conn->error}");

Upvotes: 0

Views: 53

Answers (1)

user3305084
user3305084

Reputation:

try this

$sql = "UPDATE `orders` SET `deliv_date` = '".$deliv_date."'
                WHERE `order_id` = '".$order_id."'"

Upvotes: 1

Related Questions