How to pull album infor and song info out of mysql db?

[keith23]

Hi all . i have a mysql database for music information and it has the following fields :

id ,filename, artist, album, title, remix ,track alternate_name,
parody ,comments, genre, seconds, filesize, bitrate ,visual, url

I want a query that pulls all albums name for perticuler artist that i ask for. example : singeralbums.php?artist=andy. For each album i want artist name , album name.Furthermore i want a query that pulls all songs for perticuler album and i want these fields for it :id,filename, artist, album,title.Example albumsongs.php?album=star.

feild data type:

 

[vacunita]

This is very basic query building, where the mysql manual at mysql.om might prove usefull.

This forum is not a query repository, it is here to help if you have a problem when constructing your query, but you should at least attempt to construct one, specially one this basic.


----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.