 |  |  |  |  |  |  |  |
php mysql drop down list
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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
Posts: 1,227
Reputation: 
Solved Threads: 167
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.
•
•
•
•
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.
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
Posts: 1,227
Reputation:
Solved Threads: 167
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: Jun 2007
Posts: 1,227
Reputation:
Solved Threads: 167
i have finished the code. try it here: http://68.103.192.2:8080/thunderbbolt/index.php.
•
•
•
•
Originally Posted by kkeith29
i have finished the code. try it here: http://68.103.192.2:8080/thunderbbolt/index.php.
•
•
Join Date: Jun 2007
Posts: 1,227
Reputation:
Solved Threads: 167
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.
|
Similar Threads
- PHP and MySQL Web Development (PHP)
- 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)
- Blank drop list (PHP)
Other Threads in the PHP Forum
- Previous Thread: statement to open new url and close calling page.
- Next Thread: Email Form - Checkbox help
| Thread Tools | Search this Thread |
Latest PHP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for PHP
.htaccess access ajax apache api array autosuggest beginner binary broken cakephp checkbox class cms code cron curl database date directory display download dynamic echo email emptydisplayvalue error explodefunction file files folder form forms function functions google hack href htaccess html image include insert integration ip java javascript joomla keywords limit link login loop mail menu methods mlm mod_rewrite multiple mysql oop parse paypal pdf php problem query radio random recursion regex remote script search searchbox select server sessions sms soap source space speed sql structure syntax system table tutorial update upload url validation validator variable video web website xml youtube
