show the image file using array

[edikasim81]

Hello everybody..

can u give me an idea to solve my problem..i create one page to to show image file from database(address file)..i no had a problem to show the table from database using this code :

<?
$query = "SELECT * FROM photo_list WHERE id = '$id'";
$result = mysql_db_query($dbname,$query);

		  while ($row = mysql_fetch_array($result)) {

		  $bil = $row["bil"];
		  $picture = $row["picture"];

		  ?> 	
		  <tr>
		    <td valign="top"><img src="imj/photogallery/<? echo $picture ?>?bil=<? echo $bil ?>" width="100" height="100"></td>
		  </tr>

		 <?  } ?>

..
can u give me a code to show the field from table in format 3x3...

10q.

[leatherback]

Hi,

like this:

<?
$query = "SELECT * FROM photo_list WHERE id = '$id' limit 0 9";
$result = mysql_db_query($dbname,$query);
$i = 0;

while ($row = mysql_fetch_array($result)) {


if($i==3)
  {
  echo "</tr><tr>";
   $i =0;
  }

echo "<td valign=\"top\"><img src=\"imj/photogallery/".$row["picture"]."?bil=". $row['bil']."\" width=\"100\" height=\"100\"></td>";

$i++;

}

[edikasim81]

🙂