[RESOLVED] Using a php variable as part of a path.

facarroll

I'm trying to display an array of images on a webpage by using the following code but it doesn't work. Is there some problem using a variable in a path name? Or am I doing something else that is wrong?


$query = mysql_query("SELECT title FROM topics WHERE managerId='".$managerId."' AND egroup1='"."1"."' ORDER BY title ASC"); 

while($row1 = mysql_fetch_array($query))
{
$thumbnail .= $row1['title']."<br />";
}
                 <table>
                    <tr>
                      <td><img src="images/<?php echo $thumbnail ?>" /></td>
                    </tr>
                  </table>

NogDog

A couple issues. First, it looks like you forgot to exit out of PHP mode:

<?php

while ($row1 = mysql_fetch_array($query)) {
   $thumbnail.= $row1['title'] . "<br />";
}
// need the closing tag here:
?>
                  <table>
                    <tr>
                      <td><img src="images/<?php echo $thumbnail ?>" /></td>
                    </tr>
                  </table>

On top of that, the logic is strange in that it makes no sense to have the "<br />" tag at the end of a string that is going to be used as an image path.

facarroll

Thanks for the reply. I did have the closing tag. Just missed it in my edit. I'm using the <br /> tag to set up a new row for the next line on the web page.
The code I've got will display an array of image filenames, and I want to be able to use that array to name an image source, given that the images are not in the database. Only their filenames are there.
Is there anything wrong with this syntax?

<img src="images/<?php echo $thumbnail ?>" />

NogDog

Then you need to include the HTML within the while loop.

<table>
  <tr>
    <td>
<?php
while ($row1 = mysql_fetch_array($query)) {
   $thumbnail.= $row1['title'];
   echo "      <img src='image/{$row1['title']}' alt='' /><br />\n";
}
?>
    </td>
  </tr>
</table>

facarroll

Thanks. That seems to be a soution. I'll take a while to sort it properly. Great to have good help.

facarroll

Thanks. It did work out.