php and sql

[light-angel]

hi on this script add record works ok but not update or delete

this is the error message i get Error of syntax close of '' to line 1

the file is attached as it is to big to add here

[laserlight]

Come up with the smallest and simplest script that demonstrates the error. Dumping a bunch of code and asking people to debug it is poor form.

[foyer]

from your update function..

  $sql = "update `hub1` set `hub1`=" .sqlvalue(@$_POST["hub1"], true).", `hubname1`=" .sqlvalue(@$_POST["hubname1"], true).", `address1`=" .sqlvalue(@$_POST["address1"], true).", `port1`=" .sqlvalue(@$_POST["port1"], false).", `owner1`=" .sqlvalue(@$_POST["owner1"], true).", `dchubaddress1`=" .sqlvalue(@$_POST["dchubaddress1"], true) ." where " .primarykeycondition();

pass all the BS.. look at your primarykeycondition function..

function primarykeycondition()
{
  global $_POST;
  $pk = "";
  return $pk;
}

I have to admit, a lot of your coding methods don't make sense to me.. anyway you can't update because your not telling SQL what to update!