IMAGE DISPLAYING FROM DATABASE

[baber_abbasi]

I am using a script to display image from database. I want to display all images from my table onto the page. The code I am using is following and I will appreciate ur help if necessary modifications are made into it as required.

 

\"

$dbServer = \"localhost\";

$dbDatabase = \"blob\";

$dbUser = \"root\";

$dbPass = \"\";

 

$sConn = mysql_connect($dbServer, $dbUser, $dbPass)

or die(\"Couldn\'t connect to database server\");

 

$dConn = mysql_select_db($dbDatabase, $sConn)

or die(\"Couldn\'t connect to database $dbDatabase\");

 

$result = mysql_query(\"SELECT * FROM myBlobs\");

if(mysql_num_rows($result) > 0)

{

$row = mysql_fetch_array($result);

do{

 

$dd = $row[\'blobData\'];

print($dd.\"<BR>\");

$row = mysql_fetch_array($result);

}while($row);

 

}else{echo\"No record\";}

\"

 

From above code, it displays only first image and don\'t increment to next which it should be. Please tell me how sould I resolve this problem.

 

 

Thankx

[shivabharat]

Try this :roll:

 

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



if(mysql_num_rows($result) > \'0\') 

{ 

   do{ 



             $dd = $row[\'blobData\']; 

              print($dd."<BR>"); 

               $row = mysql_fetch_array($result); 

        }while($row=mysql_fetch_array($result)); 



}else{echo"No record";} 

[baber_abbasi]

Thankx for ur help.

 

I tried this but get same output thatis only forst image from table is displayed. Couldu plz check it again?

 

Thankx again.

[shivabharat]

Hope thsi works :roll:

 

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



if(mysql_num_rows($result) > \'0\') 

{ 

   do{ 



             $dd = $row[\'blobData\']; 

              print($dd."<BR>"); 

       }while($row=mysql_fetch_array($result)); 



}else{echo"No record";}