php VIDEO of the day. help

[nemmy]

hello,
i can find a script nowhere.
i want to make a custom script that plays youtube videos for every day.
something like this one
ill insert all the youtube video links in a php file,
and for each video a date 28-02-2010
and then every day to select the apropriate video from that list.
any idea?
thank you for your time!

$slot_imgs = array( '559' => 'http://www.993thebuzz.com/onair-generic.jpg',
                    '959' => 'http://www.993thebuzz.com/onair-generic.jpg',
                   '1459' => 'http://www.993thebuzz.com/onair-rob.jpg',
                   '1859' => 'http://www.993thebuzz.com/onair-mike.jpg',
                   '2259' => 'http://www.993thebuzz.com/onair-dia.jpg',
                   '2359' => 'http://www.993thebuzz.com/onair-generic.jpg');

$time_now = (int) (date('G') . date('i'));
foreach ($slot_imgs as $time_slot => $img) {
    if ($time_now <= $time_slot) {
        echo '<img src="' . $img . '">';
        break;
    }
} 

[bradgrafelman]

Are you trying to display every value that is less than or equal to the current day, or only the single value (if any) equal to the current day? Your code is attempting to do the former, while your description sounds more like the latter.

[nemmy]

hello again iam trying to do that:

<?php

$dbhost = 'localhost';
$dbuser = '**********';
$dbpass = '**********';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$dbname = '************';
mysql_select_db($dbname);


$show = "SELECT youtubeID FROM vids WHERE vidDate=DATE(NOW())";
$result = mysql_query ($show);
while ($show = mysql_fetch_array($result))
{
$youtubeID= $show[youtubeID];
}
?>
<object width="265" height="200"><param name="movie" value="http://www.youtube.com/v/<?php echo $youtubeID; ?>?fs=1&hl=en_GB&rel=0"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/<?php echo $youtubeID; ?>?fs=1&hl=en_GB&rel=0" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="265" height="200"></embed></object>

<?php
mysql_close($conn);
?>

every day will have only one video and will display it every year the same video.
the above code seems to be working but i have stoked in something else:
i want if a day has not entry (video) then to display a random video from that table.

[nemmy]

also with the above script iam comarind the video date with the date(now()) so the next year 2011 ill have to change again the year of the vids to 2011, so i must find a solution to comprare the month and the day wothout the year ( i mean to extract the month-day from hte date and compare it woth the date(now()).

iam too close but i have stacked

[dagon]

you can use mysql functions month and day

MONTH(CURDATE())=MONTH(vidDate) AND DAY(CURDATE())=DAY(vidDate)