$username=$_GET["username"];
if ($username!="") {
$query=mysql_query("SELECT userid FROM user WHERE username='".addslashes(htmlspecialchars($username) )."'");

if(!mysql_error()) {
$user=mysql_fetch_array($query);
} else {
print "Error";
}
$userid=$user[0];
if (!$userid==0) {
$usernfo = mysql_query("SELECT * FROM user WHERE userid='$userid'");
$userinfo=mysql_fetch_array($usernfo);
$userfield=mysql_fetch_array($userfield);


echo
LF, $userinfo[username],
LF, $userinfo[posts],
LF, $userinfo[races],
LF, $userinfo[hacks],
LF, $userinfo[scans],
LF, $userinfo[pubs],
LF, $userinfo[leeched],
LF, $userfield[country], LF,
$team;

hi all im trying to call data from the userfield is that the right way to add it
all im after doing is calling

There is no query for userfield so all you will get is an error for $userfield=mysql_fetch_array($userfield);

add new query above
$userfield=mysql_fetch_array($userfield);
add:
$userfield = mysql_query("SELECT * FROM $userfield WHERE userid='$userid'");

Now depending on the field name you would then call it with $userfield[field6] where field6 is the name if could be field5 or field7 etc depending on how many field you have in the userfield table.

thanks again thats the second time you saved me