How do I keep my form updates from overwriting data?

[Marco van Herwaarden]

This is gonna be very easy.

In your template you have already this line:

<input type="text" class="bginput" name="firstname" size="20" maxlength="30" />

Change that to:

<input type="text" class="bginput" name="firstname" size="20" maxlength="30" value="$data[firstname]"/>

You can just add the value statements for each field.

Some more, the following:

PHP Code:

        $result_data = $DB_site->query("
            SELECT firstname,lastname,text,gender,age,email,bmonth,bday,byear,talent,address,addres  s2,city,state,postal,country,phone,phone2,phone3,phone4,website,insstatus,aftra,  sag,natas,experience,breast,cup,waist,height,weight,hips,dress,shoes,chest,insea  m,ethnic,stone,hcolor,ecolor,hstyle,piercings,glasses,braces,handicap,hearing,ma  rks,beard,moustache,tattoos,runway,fashion,printmedia,casual,commercial,editoria  l,tradeshow,spokesmodel,sports,swimwear,artmodel,fineartphoto,fineart,photomodel  ,perfart,internet,bodyart,lingerie,glamour,acting,singing,dance,voiceover,stage,  film,television,language,language2,flying,swimming,horse,skydiving,scuba,climbin  g,noagent,likeagent,agencyname,address3,address4,agentname,agencycity,agencystat  e,agencypostal,agencycountry,phone5,phone6,maillist,newsletter FROM " . TABLE_PREFIX . "vbportfolio_users WHERE userid = $id
        ");
 
        $count = 0;
        $data = $DB_site->fetch_Array($result_data); 


Can also be written like:

PHP Code:

        $data = $DB_site->query_first("
            SELECT firstname,lastname,text,gender,age,email,bmonth,bday,byear,talent,address,addres  s2,city,state,postal,country,phone,phone2,phone3,phone4,website,insstatus,aftra,  sag,natas,experience,breast,cup,waist,height,weight,hips,dress,shoes,chest,insea  m,ethnic,stone,hcolor,ecolor,hstyle,piercings,glasses,braces,handicap,hearing,ma  rks,beard,moustache,tattoos,runway,fashion,printmedia,casual,commercial,editoria  l,tradeshow,spokesmodel,sports,swimwear,artmodel,fineartphoto,fineart,photomodel  ,perfart,internet,bodyart,lingerie,glamour,acting,singing,dance,voiceover,stage,  film,television,language,language2,flying,swimming,horse,skydiving,scuba,climbin  g,noagent,likeagent,agencyname,address3,address4,agentname,agencycity,agencystat  e,agencypostal,agencycountry,phone5,phone6,maillist,newsletter FROM " . TABLE_PREFIX . "vbportfolio_users WHERE userid = $id
        ");
 
        $count = 0; 


And probably even better like:

PHP Code:

        $data = $DB_site->query_first("
            SELECT * FROM " . TABLE_PREFIX . "vbportfolio_users WHERE userid = $id
        ");
 
        $count = 0;