Picture Help Please

[phpretard]

This seems simple enough to me BUT...there are 10 images in the database and this will only display 1

 

Does anyone know why?

 

Oh please help me...(my eyeballs hurt)

 

<?php

include "connect.php";

    
$result = mysql_query("SELECT * FROM pictures");

while($row = mysql_fetch_array($result))

      { 
       $data = $row[bin_data]; 
       $type = $row['file_type']; 
       echo $data;
      } 
?>

[cooldude832]

lets try a few things to make it better

<?php

include "connect.php";

    
$result = mysql_query("SELECT * FROM pictures") or die(mysql_error());
echo "Number of images: ".mysql_num_rows($result)."<br />";
while($row = mysql_fetch_array($result)){ 
       $data = $row[bin_data]; 
       $type = $row['file_type']; 
       echo $data."<br />";
      } 
?>

[phpretard]

THANK YOU FOR RESPONDING SO QUICKLY!

 

I can tell it is shows all of the pictures now BUT...

 

The picture is in binary code ???

 

[budimir]

THANK YOU FOR RESPONDING SO QUICKLY!

 

I can tell it is shows all of the pictures now BUT...

 

The picture is in binary code ???

 

 

Of course it's in a binary mode. You did nothing to convert it back.

 

A much better and simplier solution is that you upload all the files somwhere in dir and you store only the name of the picture in db.

[phpretard]

You're right.

 

Again thank you for the quick response

[PFMaBiSmAd]

Every image on a web page requires its' own <img src="url" alt=""> tag. The "url" corresponds to the url that causes the image header (your posted code is not outputting any header) and image data to be output.