Forum Home Forum Home > Site News, Newbies, Help and Improvements > Help us improve the site
  New Posts New Posts RSS Feed - to PA admins
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Topic Closedto PA admins
 Post Reply Post Reply
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
dima_olkov View Drop Down
Forum Senior Member
Forum Senior Member
Avatar

Joined: September 23 2005
Location: Russian Federation
Status: Offline
Points: 143 		Direct Link To This Post Topic: to PA admins
    Posted: March 30 2006 at 03:48

Hi!

Is there any possibility on the site to search for musicians (not only bands or CDs)?

for example, i want to see all the projects/albums where tony levin played.

can i do that? if not, why don't you make it possible? thnx.
PF, Genesis, KC, Yes, VdGG, GG, Camel, Jethro Tull
Back to Top
Easy Livin View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator / Retired Admin

Joined: February 21 2004
Location: Scotland
Status: Offline
Points: 15585 		Direct Link To This Post Posted: March 30 2006 at 03:54
There is no such facility at present dima_olkov, and while it would be a great enhancement, it would be a massive task to implement.
Back to Top
dima_olkov View Drop Down
Forum Senior Member
Forum Senior Member
Avatar

Joined: September 23 2005
Location: Russian Federation
Status: Offline
Points: 143 		Direct Link To This Post Posted: March 30 2006 at 04:04
well, I'm myself a web-programmer as well as a database programmer... I definately know what it takes ;-)
PF, Genesis, KC, Yes, VdGG, GG, Camel, Jethro Tull
Back to Top
Easy Livin View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator / Retired Admin

Joined: February 21 2004
Location: Scotland
Status: Offline
Points: 15585 		Direct Link To This Post Posted: March 30 2006 at 04:22
It's not the programming which would be the issue, it's collating the data.Wink
Back to Top
Fitzcarraldo View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: April 30 2004
Location: United Kingdom
Status: Offline
Points: 1835 		Direct Link To This Post Posted: April 03 2006 at 19:26

It shouldn't be too difficult, Easy Livin. The line-up for each album is stored in the relational database, so an SQL query could be constructed to return a list of albums for a particular keyword (artist's name) within the line-up column in the database. The result of the query could be presented as a tabular list of all the albums, ordered by group/artist and date for example, and with the album name being a hyperlink to the album's page in the Archives.

 
Read reviews by Fitzcarraldo
Back to Top
Easy Livin View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator / Retired Admin

Joined: February 21 2004
Location: Scotland
Status: Offline
Points: 15585 		Direct Link To This Post Posted: April 04 2006 at 11:49

Fair point Fitz. Remember though that the line up info is effectively in free form format, not in individual fields. The forum search facility was recently pulled back from allowing searches through the "body text" for performance issues, so their may be the same implications here.

The other point I'd make is that the various artist albums do not tend to hold full line up info, and that is probably where a major benefit of this suggestion could be.

Don't get me wrong, I do agree it is a constructive and worthwhile suggestion, and one I'm sure M@X will put on the wish list!
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.188 seconds.
Donate monthly and keep PA fast-loading and ad-free forever.