Displaying multiple images stored in a folder/directory

[wuodpam]

I've resorted to storing my images by uploading them into a folder but storing the image information and the folder path in my database.
This seem to work FINE for profile images.However when I want to view multiple friend images of an individual,the browser hangs up... A look at my task manager shows me the resources are spiking up...

What i'm trying to do is display 3(per row)X 2 = 6 total friend images for an individual....which causes it to hang up..

what is wrong with this code snippet? It only works for one particular case..but hangs up on the rest.I have to turn off my pc then..

$query22 = mysqli_query($link,"SELECT person.Person_Id as Person_Id1 ,person.Person_Name as Person_Name,person.Person_City as Person_City,person.Person_State as Person_State,person.Photo_Path as Photo_Path1,person.Online_YN as Online_YN
FROM XX INNER JOIN YYYY ON person.Person_Id=friends.Friend_To and friends.Friend_Main='$Person_Id' limit 6");

	//mysqli_query($link,$query2);
	 $row_count=0;
	 $row=0;
	 //$col_count=0;

echo "<table class='tab1' border='0' width='250' cellpadding='2' cellspacing='2' align='center' valign='top'>";

while ($row<3)
{
//$row = ;

echo "<tr>";
  $col=0;
 // mysqli_fetch_array($query22);


  while($col<3)

{
$row = mysqli_fetch_array($query22);
$Person_Id1=$row['Person_Id1'];
$Person_City=$row['Person_City'];
$Person_Name=$row['Person_Name'];
//$Photo_Name=$row['Photo_Name'];
//$Photo_Name=$row['Photo_Name'];
$Photo_Path1=$row['Photo_Path1'];
$Isonline=$row['Online_YN'];
//echo $Photo_Name ;
//echo "<td><A HREF='MMM.php?Person_Id=$Person_Id'><img src='$Photo_Path' alt='ji width='53' height='50'></a>$Photo_Name</td>";
if($Photo_Path1==""){
echo"<td><A HREF=MMM.php?Member_Id=$Person_Id1'><img src='no_image1.jpg' alt='ji'/></a></td>";
}

 if($Photo_Path1!=""){
echo"<td><A  HREF='display_creator.php?Member_Id=$Person_Id1'><img src='$Photo_Path1' width='60' height='60' alt='ji></a></td>";}

   $col++;
}
echo "</tr>";

$row_count++;
}
//$Photo_Name=stripslashes($Photo_Name);

echo "</table>";

[sneakyimp]

Try formatting your code in your post using [/code] after the code and

 before.  As it is posted, it's hard to tell what's going on.

[HalfaBee]

your while uses $row and you inc $row_count++;

[wuodpam]

I have formatted the code...

It still hungs up.

<?php

$query22 = mysqli_query($link,"SELECT person.Person_Id as Person_Id1 ,person.Person_Name as Person_Name,person.Person_City as Person_City,person.Person_State as Person_State,person.Photo_Path as Photo_Path1,person.Online_YN as Online_YN
FROM XX INNER JOIN YYYY ON person.Person_Id=friends.Friend_To and friends.Friend_Main='$Person_Id' limit 6");

//mysqli_query($link,$query2);
$row_count=0;
$row=0;
//$col_count=0;
echo "<table class='tab1' border='0' width='250' cellpadding='2' cellspacing='2' align='center' valign='top'>";

while ($row<3)
{
echo "<tr>";
$col=0;
while($col<3)
{
$row = mysqli_fetch_array($query22);
$Person_Id1=$row['Person_Id1'];
$Person_City=$row['Person_City'];
$Person_Name=$row['Person_Name'];
$Photo_Path1=$row['Photo_Path1'];
$Isonline=$row['Online_YN'];

                               if($Photo_Path1==""){
                         echo"<td><A HREF=MMM.php?Member_Id=$Person_Id1'><img src='no_image1.jpg' alt='ji'/></a></td>";
                                                   }
				              if($Photo_Path1!=""){
                          echo"<td><A HREF='display_creator.php?Member_Id=$Person_Id1'><img src='$Photo_Path1' width='60' height='60' alt='ji></a></td>";}

                   $col++;
                }

echo "</tr>";
$row_count++;
}
echo "</table>";

?>

[sneakyimp]

You aren't using the tags. This is formatted code:

<?
echo 'hello world'];
?>

Did you see HalfaBee's post?

[HalfaBee]

change $row_count++ to $row++ <sigh>

<?php
$query22 = mysqli_query( $link, "SELECT person.Person_Id as Person_Id1 ,person.Person_Name as Person_Name,person.Person_City as Person_City,person.Person_State as Person_State,person.Photo_Path as Photo_Path1,person.Online_YN as Online_YN
FROM XX INNER JOIN YYYY ON person.Person_Id=friends.Friend_To and friends.Friend_Main='$Person_Id' limit 6" );//mysqli_query($link,$query2);
$row_count = 0;
$row = 0;//$col_count=0;
echo '<table class=\'tab1\' border=\'0\' width=\'250\' cellpadding=\'2\' cellspacing=\'2\' align=\'center\' valign=\'top\'>';

while( $row<3 )
{
	echo '<tr>';
	$col = 0;

while( $col<3 )
{
	$row = mysqli_fetch_array( $query22 );
	$Person_Id1 = $row[ 'Person_Id1' ];
	$Person_City = $row[ 'Person_City' ];
	$Person_Name = $row[ 'Person_Name' ];
	$Photo_Path1 = $row[ 'Photo_Path1' ];
	$Isonline = $row[ 'Online_YN' ];

	if( $Photo_Path1 == '' )
	{
		echo"<td><A HREF=MMM.php?Member_Id=$Person_Id1'><img src='no_image1.jpg' alt='ji'/></a></td>";
	}

	if( $Photo_Path1 != '' )
	{
		echo"<td><A HREF='display_creator.php?Member_Id=$Person_Id1'><img src='$Photo_Path1' width='60' height='60' alt='ji></a></td>";
	}

	$col++;
}

echo '</tr>';
$row++;   //$row_count++;
}

echo '</table>';
?>