Emergency - All records replaced
Moderator: General Moderators
Why write your SQL like that...just seems to consfuse things more.
something like this i more readable IMO...no need for all that concatenation
something like this i more readable IMO...no need for all that concatenation
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."'";- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia