Well hello, I'm just trying to update (add 1) to the "receiptno" field in "numbers"
table and display the new receiptno. At a loss
-------------------------------------------------------
the code:
<?php
//Open a new connection to the MySQL server
require_once "getprerentdb.php";
echo "<center>";echo date('m/d/y');
$id="id";
$receiptno = "receiptno +1";
$sql = "UPDATE numbers SET
receiptno='$receiptno' Where id='".$_POST['id']."'";
mysqli_query($sql) or die(mysql_error());
echo "Record for receiptno ".$_POST["receiptno"]." has been updated";
echo "receiptno ".$_POST["receiptno"]." ";
?>
-----------------------------------------------------------------------------
errors:
Notice: Undefined index: id on line 8
Warning: mysqli_query() expects at least 2 parameters, 1 given on line 9
Fatal error: Uncaught Error: Call to undefined function mysql_error() on line 9
table and display the new receiptno. At a loss
-------------------------------------------------------
the code:
<?php
//Open a new connection to the MySQL server
require_once "getprerentdb.php";
echo "<center>";echo date('m/d/y');
$id="id";
$receiptno = "receiptno +1";
$sql = "UPDATE numbers SET
receiptno='$receiptno' Where id='".$_POST['id']."'";
mysqli_query($sql) or die(mysql_error());
echo "Record for receiptno ".$_POST["receiptno"]." has been updated";
echo "receiptno ".$_POST["receiptno"]." ";
?>
-----------------------------------------------------------------------------
errors:
Notice: Undefined index: id on line 8
Warning: mysqli_query() expects at least 2 parameters, 1 given on line 9
Fatal error: Uncaught Error: Call to undefined function mysql_error() on line 9