why is tjis not updating

itsme · **Joined:** Mon Apr 03, 2023 9:50 pm **Posts:** 5

Quote:

This code is just to update the receiptno by adding 1 and displaying the value of receiptno.
The only prob, it does neither.?? says "updated but NOT

Code:

<?php
$link = mysqli_connect("localhost", "root", "", "homedb"); 
// Check connection
if($link === false){ die("ERROR: Could not connect. " . mysqli_connect_error()); }

$id = 'id';
$receiptno='';

/* Perform a query, check for error */
$sql = "UPDATE control SET 
receiptno = '$receiptno' + 1 where id='$id'";
echo $receiptno;
 if(mysqli_query($link, $sql)){ echo "updated"; } 
else { echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); }
 // Close connection
mysqli_close($link); 
?>

Admin · **Joined:** Wed Sep 12, 2007 2:18 pm **Posts:** 3949

Hi.

Here is the correct code:

Code:

$sql = "UPDATE control SET receiptno = receiptno + 1 where id='$id'";

(initially receiptno should be =0 in the database)

Regards,
Codelobster Team.

CodeLobster IDE

why is tjis not updating

Who is online