Page 1 of 1

URL point to the song and author

Posted: Fri Sep 01, 2006 3:04 pm
by bluelad
I was wondering if something like this can be done

song by author...........where songs and author autoamtically refer to the URL of that song. I am using song, author and the URL as separate fields in the table. So i would have to fetch 3 rows.....but how do i make the URL point to the song and author

Posted: Fri Sep 01, 2006 5:36 pm
by feyd
Magic.

Generally you add some logic that knows. What that entails for your specific application is, well darn hard to tell you if you don't give us details of how it's built.

Posted: Sat Sep 02, 2006 3:01 am
by bluelad
If knew that magic i wouldnt have asked for it. :lol:
I am not good with english...so my words are well a bit "abrupt". What i want to is this.........
I give the name of the singer, name of the song and the URL where the song can be found......and the final output on my index page should be like this..... HIps dont lie by Shakira

Now i hope someone can perform the "magic"

Posted: Sat Sep 02, 2006 3:11 am
by jito
try that:

Code: Select all

//.............
//write the sql to fetch all data from ur table.
while($row=mysql_fetch_array($sql))
{
echo "<a href=".$row[url].">".$row['title']."by".$row['singer']."</a>";
//where url, title, and singer are the fields of your table.
}
//...............

Posted: Sat Sep 02, 2006 6:56 am
by bluelad
thanks dude it worked.... :lol: :lol:

Posted: Mon Sep 04, 2006 9:13 am
by jito
thanks, anything else?

Posted: Mon Sep 04, 2006 9:25 am
by toasty2
If you are serving songs in mp3 format with id3 tags, you could read those. For example, check out "Toast Radio" in my signature.

Oh, or you could use a database...