Hey guys I need some help fixing my code. I'm trying to create a page where there is a list of videos (hosted on my server, the paths to the videos are in a mysql database) and when the user clicks on the link they are taken to a page where they can view the video (via JW player). Here is what I have thus far. Any suggestions would be appreciated.

PHP Code:

 
<?php
$sql = mysql_query("SELECT * FROM videos ORDER by id DESC LIMIT 0,15");
while($row = mysql_fetch_array($sql)){
$video_title = $row['video_title'];
$video_path = $row['video_path'];
$category = $row['category'];
$description = $row['description'];
$length = $row['length'];
?>
 
<div id="links" > 
<div class="titlecell"><?php echo "<a href='player.php?player=$video_path'>$video_title</a>"; ?></div>
<div class="lengthcell"><?php echo "length: $length"; ?></div>
<div class="description"><?php echo $description; ?></div>
 
</div>
</div>
<?php
}
?>

and the problem is ?

Ohh so the problem is how do I get from what I have in my frst post to showing the video on the target page. The code for the flash player on the target page is shown below. Basically where you see <?php echo ######; ?> is what I'm trying to figure out. how can I echo out the path of the video to be shown, and therefore play the video.

 
<script type="text/javascript" src="mediaplayer/swfobject.js"></script>
<div id="1"></a> </div>
<script type="text/javascript">
var so = new SWFObject('mediaplayer/player.swf','mpl','562','450','9');
so.addParam('allowscriptaccess','always');
so.addParam('allowfullscreen','true');
so.addParam('flashvars','&file=<?php echo ######; ?>&autostart=true&screencolor=#000000&bufferlength=2');
so.addVariable('screencolor','#532401');
so.write('1');
</script>
 

The snippet you gave in the first post is valid. Given that the db query is correct, and that the content of your table is too.