php code not working inside html

Question

I am trying to display an image. I have fetched my URL from the db storage. And i have used the php variable inside the image tag. But the code does'nt display any image .

what is the problem? exactly!

this is my code below

  <?php $db =& JFactory::getDBO();

            $query88=$sql = "SELECT file_url_thumb FROM fs01_virtuemart_medias WHERE virtuemart_media_id=1 LIMIT 0, 30 ";

            $result88 = mysql_query($query88) or die(mysql_error());

      ?><img src="<?php while($row = mysql_fetch_array($result88)){
            echo $row['file_url_thumb'];
            echo "<br />";
            } ?>" border="0" style="border: 0; vertical-align: top;" />

Quentin · Accepted Answer · 2012-07-16 08:25:48Z

1

You are looping over your results and putting them all (each followed by a <br /> inside the src attribute of an img tag. It seems highly unlikely that that won't 404.

You probably want something more like:

<ul>
  <?php while($row = mysql_fetch_array($result88)){ ?>
    <li><img src="<?php echo htmlspecialchars($row['file_url_thumb']); ?>" /></li>
  <?php } ?>
</ul>

(With some CSS from an external stylesheet to apply your presentation).

answered Jul 16, 2012 at 8:25

Quentin

949k136 gold badges1.3k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Peon · Accepted Answer · 2012-07-16 08:28:32Z

0

<?php

$db = &JFactory::getDBO();

$query88 = "SELECT file_url_thumb FROM fs01_virtuemart_medias WHERE virtuemart_media_id=1 LIMIT 0, 30 ";

$result88 = mysql_query( $query88 ) or die( mysql_error() );

while( $row = mysql_fetch_array( $result88 ) ) {
    echo '<img src="' . $row[ 'file_url_thumb' ] . '" border="0" style="border: 0; vertical-align: top;" /><br />';
}

?>

answered Jul 16, 2012 at 8:28

Peon

8,0417 gold badges63 silver badges104 bronze badges

Comments

Basic Bridge · Accepted Answer · 2012-07-16 08:29:20Z

0

use this

 <?php
$db = &JFactory::getDBO();

$query88 = "SELECT file_url_thumb FROM fs01_virtuemart_medias WHERE virtuemart_media_id=1 LIMIT 0, 30 ";

$result88 = mysql_query( $query88 ) or die( mysql_error() );

    while($row = mysql_fetch_array($result88)){ 
                echo '<img src="'.$row['file_url_thumb'].'" style=" border="0" style="border: 0; vertical-align: top;"/>';
                echo '</br>';
                }
                ?>

answered Jul 16, 2012 at 8:29

Basic Bridge

1,9094 gold badges25 silver badges37 bronze badges

Collectives™ on Stack Overflow

php code not working inside html

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related