Posted: Thu Jul 27, 2006 5:22 am
Ws just gonna post that I noticed that, soorry!!!!!!!!!!!1 and thanks for the help everyone
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
$sql = "UPDATE people
SET
salutation = '".$salutation."',
firstname = '".$firstname."',
surname = '".$surname."',
organisation = '".$organisation."',
role = '".$role."',
address1 = '" .$address1."',
address2 = '" .$address2."',
city = '" .$city."',
telephone = '".$telephone."',
mobile = '".$mobile."',
fax = '" .$fax."',
dateoflastcontact = '".$dateoflastcontact."',
datecontactagain = '".$datecontactagain."',
notes = '" .$notes."',
email = '" .$email."',
WHERE person_id='".$person_id."'";Yeah, good thinking Batmand11wtq wrote:I suggest adding "LIMIT 1" for safe measure. In the unlikely event something screws up at least it would only adjust one record this way.