display pic below users profile

[mirror]

hey friends i want to display the pics below users profile , this is the coding for gallery link in profile how can i display their gallery pics as thumbnails ,

$countpics = mysql_fetch_array(mysql_query("SELECT COUNT(id) FROM ibwf_usergallery WHERE uid='".$who."'"));
  echo "<a href=\"usergallery.php?action=viewuserphoto&amp;who=$who&amp;sid=$sid\">MY GALLERY</a>($countpics[0])<br/>"; 

[arnage]

Cant count that, try this. * means something like ALL

$countpics = mysql_fetch_array(mysql_query("SELECT * FROM ibwf_usergallery WHERE uid='".$who."'"));
  echo "<a href=\"usergallery.php?action=viewuserphoto&amp;who=$who&amp;sid=$sid\">MY GALLERY</a>($countpics[0])<br/>"; 

[$XTREME$]

use a while coding

[mirror]

Cant count that, try this. * means something like ALL

$countpics = mysql_fetch_array(mysql_query("SELECT * FROM ibwf_usergallery WHERE uid='".$who."'"));
  echo "<a href=\"usergallery.php?action=viewuserphoto&amp;who=$who&amp;sid=$sid\">MY GALLERY</a>($countpics[0])<br/>"; 

not working bro , do i hve to use phpthumb

[Rksk]

this code just print a link to user gallery. do u want to show photo thumbs?

[mirror]

this code just print a link to user gallery. do u want to show photo thumbs?

yes bro i want to show photos of a users profile as thumbnails below their profiles , i have the column of imageurl for path, in my ibwf_gallery , how to link it to show image , images are uploaded in folder gallery

[Rksk]

Try below one.
*I coded it using general lavalair file names. It can be changed in ur site.
*this will show 3 random photos of the user.

echo "<p><a href='gallery2.php?action=viewuserphoto&who=$who'>";

$items= mysql_query("SELECT `imageurl` FROM `ibwf_usergallery` where `uid`='$who' ORDER BY RAND() LIMIT 3");
  while ($pic = mysql_fetch_array($items))
  {
    echo "<img alt='Loading...' src='phpthumb.php?image=$pic[0]' width='30' height='30'>";
  }

echo "</a></p>"; 

[Vayne]

ORDER BY RAND() 

i hope those users dont have tons of pictures. anyway, better would be randomize in php side.

[arevel]

this is the right syntax

$countpics = mysql_num_rows(mysql_query ("SELECT * FROM ibwf_usergallery WHERE
uid='".$who."'")); echo "<a href=\"usergallery.php? action=viewuserphoto&amp;who= $who&amp;sid=$sid\">MY GALLERY</a>('.$countpics.')<br/ >"; 

.

[Rksk]

01.

ORDER BY RAND()

this will select 3 random photos only if available. if the user haven't photos, this wont return anything.

02. don't post crazy replies without reading the whole thread!