Hi everyone!
Are there any limitations on update queries, like on how many fields one
can update at the same time?
The first update query works just fine, the second does not work at all:
working :
" update memberscopy set password='$password' where name =
'$f_name' and surname ='$f_surname' "
not working:
" 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 = '$f_name' and surname = '$f_surname' "
The 2nd query works (for some fields only) on my local machine, but not
on the ISP's server....
Thanks for your help.
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
