PDA

View Full Version : Very simple I'd think, quick reply...


Tim Wheatley
02-02-2002, 02:40 AM
$DB_site->query("UPDATE user SET birthday='".addslashes($birthday)."',signature='".addslashes($signature)."',cust omtitle='$customtitle',usertitle='".addslashes($customtext)."',email='".addslash es(htmlspecialchars($email))."',parentemail='".addslashes(htmlspecialchars($pare ntemail))."',coppauser='$coppauser',homepage='".addslashes(htmlspecialchars($hom epage))."',icq='".addslashes(htmlspecialchars($icq))."',aim='".addslashes(htmlsp ecialchars($aim))."',yahoo='".addslashes(htmlspecialchars($yahoo))."',usergroupi d='$bbuserinfo[usergroupid]' $awaysql WHERE userid='$bbuserinfo[userid]',country='".addslashes($country)."' WHERE userid='$bbuserinfo[userid]'");

As you can see I'm repeating WHERE...

usergroupid='$bbuserinfo[usergroupid]' $awaysql WHERE userid='$bbuserinfo[userid]',country='".addslashes($country)."' WHERE userid='$bbuserinfo[userid]'");

Can someone tell me how I need to arrange that end of the line so both functions work? Cus they don't right now.

Ta very much.

Tim

Admin
02-02-2002, 05:10 AM
$DB_site->query("UPDATE user SET birthday='".addslashes($birthday)."',signature='".addslashes($signature)."',customtitle='$customtitle',usertitle='".addslashes($customtext)."',email='".addslashes(htmlspecialchars($email))."',parentemail='".addslashes(htmlspecialchars($parentemail))."',coppauser='$coppauser',homepage='".addslashes(htmlspecialchars($homepage))."',icq='".addslashes(htmlspecialchars($icq))."',aim='".addslashes(htmlspecialchars($aim))."',yahoo='".addslashes(htmlspecialchars($yahoo))."',usergroupid='$bbuserinfo[usergroupid]' $awaysql ,country='".addslashes($country)."' WHERE userid='$bbuserinfo[userid]'");
I think.

Tim Wheatley
02-02-2002, 05:23 AM
Tried it and it works -- Thank you very much! :D

(I love this place, you know that?) ;)