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.

<?
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.

[Joshie787]

<?
connectTOforum();

$query = mysql_query("SELECT * from user ORDER BY posts DESC LIMIT 0, 5");
while($row = mysql_fetch_array($query)){

$query2 = mysql_query("SELECT * from userfield WHERE userid='$row[userid]' ORDER BY field5 DESC LIMIT 5");
$info3 = mysql_fetch_array($query2); ?>

<li><? echo($row['username']); ?> - <? echo($info3['field5']); ?></a></li>
<? } ?>

That's what I have on my website, and it displays, I hope it helps, replace what needs to be replaced to display it from the ip address?

[masterwebguy]

Thanks. I was able to figure out how to make my own code from that.

Here it is:

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'];
}

[Joshie787]

Cool, so I was somewhat helpful :P