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.

[Joshie787]

PHP Code:

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

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


[Joshie787]

Cool, so I was somewhat helpful :P