Custom Profile Fields SQL...

[masterwebguy]

I am trying to get a custom profile field 'field5' read from the database by MY php script.

I can get the username by IP, but I don't know how to get the custom profile field.

e.g.

PHP Code:

<?
include("database.php");
$var = $_SERVER['REMOTE_ADDR'];
$set=mysql_query("SELECT * FROM user WHERE ipaddress='$var'");
while($row = mysql_fetch_array($set))
 {
$username = $row['username'];
 }

echo $username; //It's here for a specific reason but that's off the point
?>

How do I do this for field5???

Thanks.