I currently use custom fields to store the author of articles on our university paper's website.. Basically as the articles are uploaded by a number of sub editors but not usually the writer of the article we use a custom field to enter the author name.
What I would like is a list of each of the writers and a list of all the posts they have made.
So ideally I could have a page - "writers". I don't mind manually listing each writer and making a seperate call for each writer if this makes it easier - but I need some way of getting titles of all the posts with a specific custom field value..
Writer Name 1:
list all posts by writer name 1.
Writer Name 2:
list all posts by writer name 2.
http://wordpress.org/support/topic/36232 seems to be doing a pretty similar thing - but not sure what the final solution is.. I basically need help querying the post meta table to give me the list of posts for a writer..