Quote:
Originally Posted by Eidolon
I guess you could store the 'whose on air' info via a database table. The table could include a 'start time' column, along with a column defining whether it's a weekday or specific day (as presumably normal weekdays are the same). The table could also contain a column defining which file to load.
Then via PHP you could get the date & time, using the day (ie. Monday etc.) you could query along the lines for where CURRENT DATE = "Weekday" or equals "Monday" (though would need adapting to cope with weekends). It could additionally have a query where CURRENT TIME is greater than the start time (column). The query would have a limit of 1, so that only one record loads via an include.
The only complication would be where the presenter goes over midnight, in which instant two rows would probably be needed with one set to 00:00 to prevent no record/file from showing.
 |
Thanks both for your replies!
The problem I will have is that the radio station
website hosting is hosted on a server with different company (uk2 i think), as it was done before I came in. I only have FTP access to the site, and cannot do MySQL with it - but is it possible to do the database thing on my
Dedicated Server with eukhost and remotely access it?
Also I am not fluent with PHP... so if I do that I will probably be posting for help on here!!!! MySQL is fine, as I use PHPmyadmin which is pretty easy.
Thanks again!!!
Peter