Jump to content

distinctive records


s4salman

Recommended Posts

Hello

i have a mysql table namee 'lyrics'.It has so many lyrics in albums.Means for example there are 10 lyrics in one album.Table structure is as follows :

 

id|title|artist|album|lyrics

 

What i want to do is to print album name only once.Although it has been 1000 times repeated in the table with different lyrics.

 

Hope you understand what i explain here.

Please can anybody tell me how to do that? SQL sataement should i use ?

 

Thanks

 

Link to comment
https://forums.phpfreaks.com/topic/126027-distinctive-records/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.