DaniWeb Forum Index > Web Development > PHP

Showing image

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Oct 2008

Posts: 89

Reputation: sfrider0 is an unknown quantity at this point

Solved Threads: 0

sfrider0

Offline

Junior Poster in Training

Showing image

Jul 28th, 2009

I have created a database. It just contains information about websites. One column has the path to an image, like a rating system(1-5 stars). I just need to display this information on a web page. Everything shows up fine, but I just need it to display the image instead of the path to it.

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
$row_count = 0;
$columns = 3;
while ($row = mysql_fetch_assoc($result)) {
if ($row_count == $columns) {
echo "</tr><tr>";
$row_count = 0;
}
echo "<tr><td>";
echo $row['Site'];
echo "</td><td>";
echo $row['Description'];
echo "</td><td>";
echo $row['Rating'];
echo "</td>";
$row_count++;
}
?>
<?php
$row_count = 0;
$columns = 3;
while ($row = mysql_fetch_assoc($result)) {
if ($row_count == $columns) {
echo "</tr><tr>";
$row_count = 0;
}
echo "<tr><td>";
echo $row['Site'];
echo "</td><td>";
echo $row['Description'];
echo "</td><td>";
echo $row['Rating'];
echo "</td>";
$row_count++;
}
?>

Any help would be greatly appreciated!

•

Join Date: Apr 2006

Posts: 28

Reputation: anuradhu is an unknown quantity at this point

Solved Threads: 2

anuradhu

Offline

Light Poster

Re: Showing image

Jul 28th, 2009

Use the <img tag inside the ECHO statement.

•

Join Date: Feb 2008

Posts: 89

Reputation: jino is an unknown quantity at this point

Solved Threads: 5

jino

Offline

Junior Poster in Training

Re: Showing image

Jul 28th, 2009

Like echo "<img src=\"pathto image[imagename]\" >";

We only have to do a very few things right in our life, so long as we don't do too many things wrong.

•

Join Date: May 2008

Posts: 97

Reputation: sureronald is an unknown quantity at this point

Solved Threads: 16

sureronald sureronald is offline

Offline

Junior Poster in Training

Re: Showing image

Jul 28th, 2009

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
 
      <?php
 
      $row_count = 0;
        $columns = 3;
 
      while ($row = mysql_fetch_assoc($result)) {
 
      if ($row_count == $columns) {
 
      echo "</tr><tr>";
 
      $row_count = 0;
 
      }
 
      echo "<tr><td>";
 
      echo $row['Site'];
 
      echo "</td><td>";
 
      echo $row['Description'];
 
      echo "</td><td>";
 
      echo "<img src=\"{$row['Rating']}\" alt=\"{$row['Description']}\" />";
 
      echo "</td>";
 
      $row_count++;
 
      }
 
      ?>
  
      <?php
  
      $row_count = 0;
        $columns = 3;
  
      while ($row = mysql_fetch_assoc($result)) {
  
      if ($row_count == $columns) {
  
      echo "</tr><tr>";
  
      $row_count = 0;
  
      }
  
      echo "<tr><td>";
  
      echo $row['Site'];
  
      echo "</td><td>";
  
      echo $row['Description'];
  
      echo "</td><td>";
  
      echo "<img src=\"{$row['Rating']}\" alt=\"{$row['Description']}\" />";
  
      echo "</td>";
  
      $row_count++;
  
      }
  
      ?>

Not the alt attribute with the description just in case the image fails to load.