Posted by Jim Hernandez on 11/12/05 02:47

i have two tables. artists and reviews.
reviews:
albumid (pk)
artistid (fk)
albumname

artists:
artistid (fk)
artistname

I want to implement data from these tables into a php page that lists
artists alphabetically and underneath each artist lists the albums that
they have reviews for.
e.g.,: blah band
-the blah bands greatest hits
-blah blah blah

Any help is appreciated

[Back to original message]