Forum Moderators: coopster
it could be any number of thumbs from 2 to 9
as is it dislays all the thumbs
but I need to only grab 2 thumbs per user
how can I limit the number within the iteration to only two per iteration before passing to the following user etc...
$conn=db_connect();
$sql = "SELECT distinct i.id, i.thumb_name, i.img_id, i.img_gal,
p.dog_name, p.id, p.breed, p.coat, p.fav_treat, p.fav_food, p.fav_toy, p.movie, p.activity,
p.username, p.address_visible, p.town, p.state, p.email, p.email_visible, p.story, p.book
FROM profile p, img_2 i
WHERE p.breed='$breed' AND p.username=i.img_gal order by 'p.id' "; //echo"$sql";
$result = mysql_query($sql);
$num=mysql_num_rows($result);
$i=0;
while ($i <$num)
{
$dog_name= mysql_result($result,$i,"dog_name");
$breed= mysql_result($result,$i,"breed");
$coat= mysql_result($result,$i,"coat");
$fav_treat= mysql_result($result,$i,"fav_treat");
$fav_food= mysql_result($result,$i,"fav_food");
$fav_toy= mysql_result($result,$i,"fav_toy");
$movie= mysql_result($result,$i,"movie");
$activity= mysql_result($result,$i,"activity");
$username= mysql_result($result,$i,"username");
$address_visible=mysql_result($result,$i,"address_visible");
$email_visible= mysql_result($result,$i,"email_visible");
$story= mysql_result($result,$i,"story");
$book= mysql_result($result,$i,"book");
/////////////////////////////////////////////////////
$thumb_name= mysql_result($result,$i,"thumb_name");
$first_pic=$thumb_name;
$img_id=mysql_result($result,$i,"img_id");
$first_pic = "<img src=\"../advantages/galleries/all_gal/$username/thumbs/$thumb_name\">";
/////////////////////////////////////////////////////
$i++;
} // ends WHILE
if user == user from last iteration AND number of images displayed < maxperuser
then display another thumb and increment number of images displayed
else set number of images displayed to 0 and next iteration
