Hi, please advise how to resolve. I want to print the receiptno on a receipt and it prints
"receiptno". I don't know how to define "receiptno" to use the value in the table.
I'm working with mysqli and having trouble with this code:
$receiptno='receiptno';
$sql = "UPDATE numbers SET receiptno = receiptno+1 WHERE id=1"; // ************ updates
if ($conn->query($sql) !== true) { echo "Failed to update receiptno"; }
else { echo " "; }
echo "receipt # is " .$receiptno . "<br>";