Home     Articles & Projects     Products & Web Services

seem if song time has already past

Hi I am looking for away to do the following.
In my database I have the following rows

songLength
Timestamp <-Time song started playing

in my PHP script I use $now to get the current time.

What i would like to do is find out if the song has finished playing and if it has I want to be able to show a message saying "This song finished X min/hours ago.

I am also having an issue with these two rows
t1.radio_now_playing_artist as song, <- this should be artist
t1.radio_now_playing_song as artist, <- this should be song

But when I do it
t1.radio_now_playing_artist as artist,
t1.radio_now_playing_song as song,

the $song shows the artist and the $artist shows the song...

here is the PHP code I use to get the data.

{code saved}

Hi Russell, Looks like a

Hi Russell,

Looks like a simple typos in your script; it does actually have:

t1.radio_now_playing_artist as song,
t1.radio_now_playing_song as artist,

...I guess that should be:

t1.radio_now_playing_artist as artist,
t1.radio_now_playing_song as song,

Cheers!
David.

Yeah tried that but get the

Yeah tried that but get the same error.