mySQL help

[sevenstar]

I am using the openBB forum on my site. I edited the tables and added a field called referredby, which is where registrant's enter the name of the member that referred them to the site. You are able to enter something, but when I look in the database, the field is blank. What am I doing wrong?

[Damian]

Can you post some code?

D

[sevenstar]

from the profiles template:

<tr>
<td bgcolor="$tempvars[primary]"><font face="$tempvars[fontface]" size="2" color="#000000"><b>&nbsp;Referred By:</b></font></td>
<td bgcolor="$tempvars[primary]"><font face="$tempvars[fontface]" size="2" color="#000000">$user[referredby]</font></td>
</tr>

this is from cp_users.php:
new query($SQL, "UPDATE profiles SET usergroup = '".$usergroup."', banned = '".$banned."', homepage = '".$homepage."', email = '".$email."', icq = '".$icq."', aim = '".$aim."', yahoo = '".$yahoo."', msn = '".$wm."', occupation = '".$occupation."', note = '".$personal."', location = '".$location."', homepage = '".$homepage."', referred= '".$referredby."

this is from cp_members.php:
$referredby= $query_users->field('referredby');

Does this help any?