I am trying to read my database from mysql. I have two fields author and books. I need the author field to be in the drop down list and then when I choose an author I need it to display below on the same page all of the books by that author in the database. I don't really know how to use php. I know how to connect the database to php but then I don't know how to get the author from the database to the drop down list and then I am not really sure how to display the books below. I am working on this for a small local bookstore and I really want to incorporate this feature for them.
thunderbbolt
0
Newbie Poster
Recommended Answers
Jump to PostWell i can help you with that. i have done this many times. if you will post the authors and the books they have, i will make a script for you that you can view on my server in a couple of hours.
Jump to Postcan i use more than one table or does it need to be in one? i will also give you code to create the database tables if you need it.
Jump to Posti have finished the code. try it here: http://68.103.192.2:8080/thunderbbolt/index.php.
Jump to Posthere is the script: http://68.103.192.2:8080/thunderbbolt/download.zip. there is a README.txt file in there i type for you, telling you everything you need to know. if there is any other questions just pm me.
Jump to Postsorry forgot something in the readme file. i have updated it. please download the zip file again.
my bad
All 17 Replies
somedude3488
228
Nearly a Posting Virtuoso
thunderbbolt
0
Newbie Poster
thunderbbolt
0
Newbie Poster
somedude3488
228
Nearly a Posting Virtuoso
thunderbbolt
0
Newbie Poster
somedude3488
228
Nearly a Posting Virtuoso
thunderbbolt
0
Newbie Poster
somedude3488
228
Nearly a Posting Virtuoso
somedude3488
228
Nearly a Posting Virtuoso
thunderbbolt
0
Newbie Poster
thunderbbolt
0
Newbie Poster
somedude3488
228
Nearly a Posting Virtuoso
thunderbbolt
0
Newbie Poster
somedude3488
228
Nearly a Posting Virtuoso
thunderbbolt
0
Newbie Poster
somedude3488
228
Nearly a Posting Virtuoso
ambiliya
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.