need help with UPDATE code

[ejg11]

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;

 

 

 

[neilfurry]

try this:

 

<?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;

[KaiSheng]

Try changing this

$Addr = $_POST['addr'];

 

to

 

$Addr = $_POST["addr"];

 

and where does your $nameid come from?