kritikia Posted October 9, 2006 Share Posted October 9, 2006 Hello all,I am a newbie,,and I am trying to retrieve & display my blob data-my all images from the DB,but with no great succes:(The only that I manage is to display 1 image The code to display the first image:<?php$conn=mysql_connect("localhost","admin","");mysql_select_db("Images") or die(mysql_error());$sql="SELECT content FROM tbl_1";$result=mysql_query($sql) or die("Invalid Query:" . mysql_error());header("Content-type: image/jpeg");$data=@mysql_result($result,0,"content");echo $data;mysql_close($conn);?>How can I modify this code to display all the images that are stored in the DB,instead of only one(,that I define which one)Can you help me??Any idea?Thanks!!Kritikia Quote Link to comment Share on other sites More sharing options...
trq Posted October 9, 2006 Share Posted October 9, 2006 Replace....[code=php:0]$data=@mysql_result($result,0,"content");echo $data;[/code]with...[code=php:0]while ($data = mysql_result($result,0,"content")) { echo $data;}[/code] Quote Link to comment Share on other sites More sharing options...
kritikia Posted October 10, 2006 Author Share Posted October 10, 2006 Hello thorpe,I did it,but still the same result.. :(It displays only one image,the first.kritikia Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.