You might be best getting a book on mysql. I use php and mysql for dynamic web sites. If you havent done databases before you are going to stuggle without it. Knowing what to set the field types to, knowing how to access it and how to populate it. There are packages for your task which would do it all for you. Without knowing your skill level its hard to suggest where to start.
If you are just having a problem creating the database and know all about it after that then i would use sqlyog i find it far better than phpmyadmin.
Sounds like some type of script you want to run there. Create a database as shown, in phpmyadmin. Done.
The installer for the script will ask this database name, as well as the root name and pass for mysql. These are the basics for any webmaster, you don't need a book on mysql unless you plan on working the data within in a table, and clearly, you don't.
Last edited by Takster on 07. June 2010 13:18, edited 3 times in total.
there is a fully free version of sqlyog, a trial version and a paid version i am using free version with out limits from what i can see. You do get a buy message on loading and on exit but the gui is far better than phpmyadmin for most tasks.
If your plan is to create a database design from scratch AND build an interface for it, that is a considerable task. Some books and perhaps an online class or training videos would be a good investment. It will also reduce your frustration and increase your chance of success.
maybe that would help.. thanks for your reply guys.. my teacher is a real freak giving us a project we didn't even know how to use the appropriate language for it.. .. thanks guys.. out for a while now..