[RESOLVED] need soome help

tommyc21

i need help with showing friends on profile in my profile.php so far i have

function friends($friends){
$sql select" from friends where addid='$profile[ID]' and accp='yes'";
$sql2 select" from friends where addedid='$profile[ID]' and accp='yes'";
$rows = 2;
$cols = 3;
$friends = 6;
}
echo "".friends()."";

can some 1 help me plz i dont realy no the function side that well

trevorsg

This code is riddled with problems, and I have no idea what you're trying to do with it.

ASAP

tommyc21;10921939 wrote:
i need help with showing friends on profile in my profile.php so far i have

can some 1 help me plz i dont realy no the function side that well

You aren't inputting anything into that function(whether you are aiming to I don't know), you also aren't returning anything to echo it out.

tommyc21

its doing my headin so just did it in basic php lol

                         $query2 = "SELECT * from friends as a,users as b where a.addid='$rprofile[ID]' and b.ID=a.addedid order by a.associd DESC limit 4";
    $command2 = mysql_query ($query2)
		or die($db_error);
    while($result2 = mysql_fetch_array($command2))
    {
			print "<center><td><a href=\"profile.php?name=".$result2[username]."\" target=\"_blank\"><img src=\"photos/$result2[mainpath]\" border=\"0\" width=\"70\" height=\"60\" /><center></a>";
		}
    print "<tr height=\"7\"><td colspan=\"4\"></td></tr></table><br><br>";