On-air script

[Anon]

Hi there!

For a local radio-station I'm am looking for an on-air script.

Any suggestions?

Thanx!
Marco de Jong
Amsterdam, The Netherlands

[[deleted]]

Ofcourse it would be silly to ask what the F you mean by an 'on-air' script?

[Anon]

Not silly at all... I've got a certain tv/radio guide. Program names and times included. I want to store it in SQL and if I log in on a webpage at say 13:04 that it shows the program that's on-air that time.

[[deleted]]

"Not silly at all..."

that was not meant as a polite question :-)

So basically you are looking for a script that does

SELECT *
FROM programs
WHERE start_time<now()
AND end_stime>now()

and prints the results.

[Anon]

True... call me stupid.

Basically like http://www.veronica.nl/multiguide , can be hand-coded. But if someone already made it, including BO. Why bother?

[[deleted]]

Stupid! :-) (well you did ask me to call you stupid)

Which database type are you (planning on) using to store the program data?

[Anon]

I'm using MySQL for this.

[[deleted]]

MySQl makes it very simple, but it'll be a custom job anyway.

Do you want top write the scripts yourself?

[Anon]

Yep, I'm going to write the scripts myself. Seems quite simple, just the admin module will be though. The schedule needs to remain the same each week, just some little changes every week. I don't want the editorial staff to keep entering the same static program info every week.

It's for http://www.tmf.nl, now you can see the TV guide and the highlights seperately. I want to integrate them.

[[deleted]]

TMF, cool. well let me know if you need any help!

[Anon]

Hey Vince!

ThanX! I'll kick something off... & let you know where I get into trouble 😉

Gr,
Marco de Jong
TMF Interactive
[e-mail]