filter results

QuizToon

Hi all

I reckon this is a simple task for one of you - just can't get my head round it.

I have a database with about 150 articles in it each article has also got a field with the authors name in it.

I would like to be able to select from a dropdown an author and have just the article titles displayed of that author so you can then select which one to read

Hope it makes sense

Many Thanks

cretaceous

your question is a bit too open ended..

get the author names and put them into a dropdown..
on submit get the author name chosen (or their id)
and use that to show the articles after doing
"SELECT books FROM booklist WHERE authorname =$_GET['authorname']"

so that's an open ended answer and will only loosely match your scenario
which bit is causing the problem?