hi, i need help

[vinny69]

hi, i need help with php coding, obviously...
i have a website where users can sign up and edit their profile, and on their profile i have a friends list, at the moment i have a database called friend, with freindid, userid, and pending, on the profile page i have this code;

<?php
$db = "dbname";
$user = "username";
$pw = "password";
$mysql_access = mysql_connect("localhost", $user, $pw);
mysql_select_db($db, $mysql_access);
$query = "SELECT * FROM friends WHERE pending='no' AND userid='".$req_user_info['username']."'";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "{$row['friendid']}";
}
?>
".$req_user_info['username']." gets the username of the profile your on

but i cant figure out how i would go about getting the friends details from their profile, e.g. their image and username....please help,
thanks

Vinny

[devphp12]

hi

if u have this friend id then make one function like friend_detail($friend id) and write query in the function

friend_detail($friend_id)
{
$q="select * from user where id=$friendid";
$n=mysql_query($q) or die(mysql_error());

return $n;

}

//user table is master table where profile is save

n display each record by fetching it