hi guys, need help with php gd image

vinny69

hey,
i have made a gd image from my database, and it works fine appart from one part...
the code get info for a certain user and puts it in the image, but i want it to display top 12 friends...

example

Here is the code i tried, it displays 12 friends in different positions by using the array, but the problem is it displays the same friend 12 times...
and i need it to not display some, if say the user only has 5 friends then it only shows 5

$a = array(25, 55, 85, 115, 145, 175, 205, 235, 265, 295, 325, 355);
    foreach($a as &$row){
        //you don't have to do anything here
       }
       unset ($row); // it is safe now to use $row again
    foreach($a as $row){  

$sql11="SELECT accessid FROM users WHERE username='".$userPart[0]."'";
$result11 = mysql_query($sql11);
while($row11 = mysql_fetch_array($result11))
 {
  $sql12="SELECT friend FROM friends WHERE user='".$row11['accessid']."' AND accepted='yes' LIMIT 0, 12";
$result12 = mysql_query($sql12);
while($row12 = mysql_fetch_array($result12))
 {


 $sql13="SELECT accessid FROM users WHERE accessid='".$row12['friend']."' LIMIT 0, 1";
$result13 = mysql_query($sql13);
while($row13 = mysql_fetch_array($result13))
 {

 $userImg = imagecreatefrompng( '../images/dp/'.$row13['accessid'].'/me.png' );

$userImgHeight = imagesx( $userImg );
$userImgWidth  = imagesy( $userImg );

// Copy
imagecopyresized($my_img, $userImg, $row, 95, 0, 0, 25, 25, $userImgWidth, $userImgHeight);

}
}
 }
  }

thanks for any help.

paulnaj

Hi,

It maybe that you're going to the db once too often. See if this makes sense...

<?php
// ... unrelated stuff here ...
	$sql11="SELECT accessid FROM users WHERE username='".$userPart[0]."'";
	$result11 = mysql_query($sql11);
	// You should check row count here but surely should be only one!
	if(mysql_num_rows($result11) != 1){
		die('Blah blah...!');
	}
	// Now get the one row ...
	$row11 = mysql_fetch_assoc($result11); // Can/should use assoc here
	// ... and use it to find friends
	$sql12="SELECT friend FROM friends WHERE user='".$row11['accessid']."' AND accepted='yes' LIMIT 0, 12";
	$result12 = mysql_query($sql12);
	// Now cycle through the friends
	while($row12 = mysql_fetch_array($result12)){
		// Since you used 'friend' as an accessid in your original code, I'm
		// assuming that this is valid
		$userImg = imagecreatefrompng( '../images/dp/'.$row12['friend'].'/me.png' );

	$userImgHeight = imagesx( $userImg );
	$userImgWidth  = imagesy( $userImg );
	// Copy
	imagecopyresized($my_img, $userImg, $row, 95, 0, 0, 25, 25, $userImgWidth, $userImgHeight);
}

?>

Paul.

vinny69

well i connected to the database 3 times because i need to to get the friend info

i connected to users to get my info

then connected to friends where the user is my accessid (as the friends tabe, has user as the users accessid, friends as the friends accessid, and accepted as yes or no)

then i connected back to users where the access id is the friends accessid

so that get their info

i use tht way to get the friends in the friends list i have...

ahhhh i get why you got rid of the 2nd user connection now, as im only getting the access id from it its pointless as it is the same id as friend in the friends table, lol

paulnaj

Er, so your code works then - why are you asking for help?

vinny69

im asking for help because if you look at the picture in my first post, you'll see that it is placing the same users picture 12 times, but i want different users

paulnaj

Why don't you try the code I posted and see what goes wrong.