hey guys

I'm having a little trouble building links to retrieve images using php variables. My server has a folder called "thumbnails" and in the folder I have sub-folders called "hockey" "basketball" "baseball" and "football", each of which hold little jpg images. I have a MySQL database that have fields called "section" and "thumbnail_path", which have a path to a specific image and the section of that image that correlate to that row of data.

Now the thumbnail image appears
when the thumbnail_path field in the db is in the form "thumbnails/hockey/rangers.jpg" and the php code is...

PHP Code:

<?php 
$thumbnail = $row['thumbnail_path'];
echo "<img src='http://www.mysite.com/$thumbnails'></img>" ; 
?>

But what I'm trying to do is set it up so that the
thumbnail_path field in the db is in the form
"rangers.jpg" and the php code is...

PHP Code:

<?php 
$section = $row['section'];
$thumbnail = $row['thumbnail_path'];
echo "<img src='http://www.mysite.com/thumbnails/$section/$thumbnail'></img>" ; 
?>

I've can't seem to get method #2 to work. any suggestions?

But what value do you have stored in the cell "section"?

For example if you have something like this:

section   |  thumbnail_path
-------------------------
hockey   |  rangers.jpg

It should work.

yes, Marik, thats exactly how I have the db setup. But it just dosn't work, I have no idea what I'm doing wrong.. heres the full codng if it helps anyone.

PHP Code:

 <?php
$get = mysql_query("SELECT * FROM videos WHERE section='other' ORDER by id DESC LIMIT $start, $per_page");
while($row = mysql_fetch_assoc($get))
{
$video_title = $row['video_title'];
$video_path = $row['video_path'];
$length = $row['length'];
$section = $row['section'];
$date_added = $row['date_added'];
$thumbnail = $row['thumbnail_path'];
?>
 
<div id = "vidfeed">
<div id = "vidfeedthumb">
<div class="thumbnail"><?php echo "<a href='player.php?v=$section/$video_path'><img src='http://www.mysite.com/thumbnails/$section/$thumbnail' alt='$video_title'></img></a>"; ?></div>  
</div>
<div id = "vidfeedinfo">
<div class="titlecell"><?php echo "<a href='player.php?v=$section/$video_path'>$video_title</a>"; ?> </div>
<div class="length"><?php echo "Added: $date_added &nbsp;&nbsp;&nbsp; Category: $section";?> </div>
</div>
</div>
 
<?php
}
?>

From the additional code you provided it looks like your query is only selecting record sets that have the value "other" for the section cell. In the first post you wanted to show a thumbnail that had for it's section value the word "hockey", so my guess is that's why it's not working.

Try this query instead:

SELECT * FROM videos ORDER by id DESC LIMIT $start, $per_page

ok nvm, problem resolved. the thumbnails files on the server had a typo in it. im an idiot