I am using a mysql database to sent out a playlist page to the user. For instance, "playlist.php". This php file contains an image with a link attached that when click will take the user to another php file titled "videos.php". Then based on my _GET I retrieve which video was selected on the previous page by its ID number. This is located in the browser's url bar as http://website.com/videos.php?v=$id
v is the _GET variable that is being looked for, and the $id just stands for the value of the video's id that was from the previous page.
How would I code this into a while loop so each page would have a specific window with only that video in that player on the following page (videos.php).
This is what I have so far. Please points out any possible issues.
I am using the code for windows media player because the url is to a wmv file.
// connect and mysql include
$id = $_GET['v'];
$query = mysql_query("SELECT url FROM sdplaylist ORDER BY id LIMIT 1");
$numrows = mysql_num_rows($query);
while ($row = mysql_fetch_assoc($query)
$id = $row['id'];
$url = $row['url'];
<OBJECT id='mediaPlayer1' width="180" height="50"
standby='Loading Microsoft Windows Media Player components...' type='application/x-oleobject'>
id='mediaPlayer' name='mediaPlayer' displaysize='4' autosize='-1'
bgcolor='darkblue' showcontrols="true" showtracker='-1'
showdisplay='0' showstatusbar='-1' videoborder3d='-1' width="420" height="380"
src="<?php echo "$url";?>" autostart="true" designtimesp='5311' loop="false">
Thank you for your time.