$DB_site->query("UPDATE usergroup SET $candeleteusercomments = intval($candeleteusercomments);candeleteusercommen ts='$candeleteusercomments',ti tle=
thats just first part of the query but gives me same error
Invalid SQL: INSERT INTO usergroup (candeleteusercomments, usergroupid,title,usertitle,cancontrolpanel,canmod ifyprofile,canviewmembers,canv iew,showgroup,cansearch,canemail,canpostnew,canmov e,canopenclose,candeletethread ,canreplyown,canreplyothers,canviewothers,caneditp ost,candeletepost,canusepm,can postpoll,canvote,canpostattachment,ismoderator,can publicevent,canpublicedit,cant hreadrate,cantrackpm,candenypmreceipts,maxbuddypm, maxforwardpm,canwhosonline,can whosonlineip,cangetattachment)
VALUES (NULL,'1','1',0,1,1,1,1,1,0,0,0,0,0,0,0,1,0,0,1,1, 1,1,0,0,0,1,0,0,0,0,1,0,1)
mysql error: Column count doesn't match value count at row 1
|
09-06-2003, 05:55 PM
Threaded Mode