•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 456,526 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,805 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 4084 | Replies: 16
 |
•
•
Join Date: Mar 2007
Posts: 18
Reputation: 
Rep Power: 2
Solved Threads: 0
Newbie Poster
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.
•
•
Join Date: Jun 2007
Location: Valley Center, Kansas
Posts: 643
Reputation:
Rep Power: 3
Solved Threads: 72
Practically a Master Poster
Well 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.
•
•
Join Date: Mar 2007
Posts: 18
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
I also have an id field which is a identification number
•
•
Join Date: Mar 2007
Posts: 18
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by kkeith29 
Well 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.
ID Author Title
1 Patricia Cornwell Preditor
2 Patricia Cornwell Cruel and Unusual
3 John Grisham The Client
4 John Grisham The Firm
5 John Grisham The rainmaker
6 James Patterson Violets are blue
7 Sue Grafton A is for Alibi
8 Janet Evanovich One for the money
9 Janet Evanovich Two for the dough
This is just part of the file
•
•
Join Date: Jun 2007
Location: Valley Center, Kansas
Posts: 643
Reputation:
Rep Power: 3
Solved Threads: 72
Practically a Master Poster
can 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.
•
•
Join Date: Mar 2007
Posts: 18
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
They only have one table.
•
•
Join Date: Jun 2007
Location: Valley Center, Kansas
Posts: 643
Reputation:
Rep Power: 3
Solved Threads: 72
Practically a Master Poster
i have finished the code. try it here: http://68.103.192.2:8080/thunderbbolt/index.php.
•
•
Join Date: Mar 2007
Posts: 18
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by kkeith29
i have finished the code. try it here: http://68.103.192.2:8080/thunderbbolt/index.php.
This is perfect and exactly what they are looking for. How did you do this? Thank you so much.
•
•
Join Date: Jun 2007
Location: Valley Center, Kansas
Posts: 643
Reputation:
Rep Power: 3
Solved Threads: 72
Practically a Master Poster
here 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.
|
•
•
•
•
•
•
•
•
DaniWeb PHP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- Apache (Linux Servers and Apache)
- PHP and MySQL newbie introducing self (PHP)
- PHP-MySQL: Registration, Leave Request, Inventory Information, etc... (PHP)
- free php/mysql programming (Web Development Job Offers)
- Hello All: PHP-MySQL Web Designers/Developers. (PHP)
- List Of Free PHP,MYSQL Webhosting Provider (PHP)
- PHP and MySQL Web Development (PHP)
- Blank drop list (PHP)
Other Threads in the PHP Forum
- Previous Thread: MySQL date formatting
- Next Thread: i am having problems send html emails from my forum
