Hi could somebody please tell me what's wrong with this query?
I just can't find the error in it..and it does not update the records at
all...
update memberscopy
set rank='$rank',
cname='$cname',
caddress='$caddress',
ctel='$ctel',
cfax='$cfax',
cmobile='$cmobile',
cemail='$cemail',
curl='$curl',
btype='$btype',
hq='$hq',
quali='$quali',
experi='$experi',
inhouse='$inhouse',
resid='$resid',
ptel='$ptel',
pfax='$pfax',
pmobile='$pmobile',
pemail='$pemail',
marital='$marital',
spouse='$spouse',
children_number='$children_number',
children_names='$children_names',
hobbies='$hobbies',
membership='$membership',
pcont='$pcont',
lastup=now()
where name = '$name' and surname = '$surname'
Thanks for your help in advance,
Sven
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
