The code I am testing does not work. I get 'affected rows (update): -1.
Can anyone tell me what I am doing wrong.
Thanks.
******************
<?php
$Fname = $_POST["fname"];
$Lname = $_POST["lname"];
$Bus = $_POST["business"];
$Addr = $_POST['addr'];
$City = $_POST["city"];
$State = $_POST["state"];
$Zip = $_POST["zip"];
$Ctry = $_POST["ctry"];
$Email = $_POST["email"];
$Ph1 = $_POST["ph1"];
$Type1 = $_POST["type1"];
$Ph2 = $_POST["ph2"];
$Type2 = $_POST["type2"];
$Ph3 = $_POST["ph3"];
$Type3 = $_POST["type3"];
$ph4 = $_POST["ph4"];
$Type4 = $_POST["type4"];
$Notes = $_POST["notes"];
if(isset($_POST["save"])):
$query = ("UPDATE directory
SET
fname='$Fname',
lname='$Lname',
bus='$Bus',
addr='$Addr'
WHERE
directory.id = '$nameid'");
$result = $mysqli->query($query);
printf("Affected rows (UPDATE): %d\n", $mysqli->affected_rows);
endif;