Thanks. I was able to figure out how to make my own code from that.
Here it is:
PHP Code:
include("database.php"); //Database connection file
$va =$_SERVER['REMOTE_ADDR'];
$set=mysql_query("SELECT * FROM user WHERE ipaddress='$var'");
while($row=mysql_fetch_array($set))
{
$username=$row['username'];
$userid=$row['userid'];
}
$query1=mysql_query("SELECT * from userfield WHERE userid='$userid'");
while ($id=mysql_fetch_array($query1))
{
$bnaccount=$id['field5'];
}