This is gonna be very easy.
In your template you have already this line:
HTML Code:
<input type="text" class="bginput" name="firstname" size="20" maxlength="30" />
Change that to:
HTML Code:
<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;
|