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
URL point to the song and author
Moderator: General Moderators
If knew that magic i wouldnt have asked for it.
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"
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"
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.
}
//...............