changing sequence of items in "editinfo" of Your A

Worker Joined: Dec 22, 2004 Posts: 135

I have manually added some entries into "editinfo" but when I click "save" the info gets altered. I'm guessing I have to keep the same sequence in this code

Code:

$db->sql_query("UPDATE ".$user_prefix."_users SET name='$

for everything to work out ok. Is this correct?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

No. There is no required order to the UPDATE statement. In other words, this all would save the data correctly.

$db->sql_query("UPDATE ".$user_prefix."_YOURTABLE SET col1='$data1', col2='$data2', col99='$data99'");

$db->sql_query("UPDATE ".$user_prefix."_YOURTABLE SET col2='$data2', col99='$data99', col1='$data1'");

$db->sql_query("UPDATE ".$user_prefix."_YOURTABLE SET col99='$data99', col2='$data2', col1='$data1'");

Posted: Sat Oct 08, 2005 9:22 am

What do I need to do to get rid of some of the "edituser" items such as ICQ, AIM, etc. I put // in front of all the lines. Should I delete them from "saveuser" function as well? Anything I'm forgetting?

Posted: Sat Oct 08, 2005 9:48 am

nm, got it... getting the hang of this stuff