be aware... linux/unix table names are case sensitive. if you're using Win32 MySQL on your system, the query might work, but on the ISP side, if it's a *NIX system... you must have the correct capitalization.
moreover, if any of your variables contain a single quote character ( ' ), it will screw up your SQL statement. make sure you run all your variables through a filter to check for single quotes. either backslash them out ( \ ) or prevent your users from using them. -Ryan Hatch Sven Bentlage wrote: > 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 --------------------------------------------------------------------- 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