help - outputting a jpeg
| From: | Ross | Date: | Tue, 29 Aug 2006 08:52:20 +0000 |
| Subject: | help - outputting a jpeg | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-241173@lists.php.net to get a copy of this message | ||
I just get all the binary data output
<?
include("includes/config.php");
$link = mysql_connect($host, $user, $password) or die ('somethng went
wrong:' .mysql_error() );
mysql_select_db($dbname, $link) or die ('somethng went wrong, DB error:'
.mysql_error() );
$query = "SELECT DISTINCT gallery FROM thumbnails";
$result = @mysql_query( $query,$link );
while ($row = @mysql_fetch_assoc($result) ) {
$gallery_id=$row['gallery'];
$query2 = "SELECT * FROM thumbnails WHERE gallery ='$gallery_id' LIMIT 1";
$result2 = @mysql_query($query2);
while ($row2 = @mysql_fetch_array($result2, MYSQL_ASSOC)){
Header( "Content-type: image/pjpeg");
echo "<img src=\"".$row2["bin_data"]."\">";
}