databses, mysql

[kumarsena]

hey jus wondering about making use of mysql to power my site. now i found some free db hosts thta give 1 db and others that give 10. but my uestion is: i have several sections on my site , cd reviews, receipes, articles and links to name a few. in terms of effective developemntr, what should i put in a databse and what should be left in flat fiels or in html fiels. and also, if i have 1 db with a db host, can i have several tabels to contains all the diffrerrnt sections, or do i need a new db for each section, say to contain cd info another db for receipes etc.. questions might sound a bit dumb, but im ne to dbs so bear with me please

thanks or any input..
oh and..does anyone knwo of any free mysql hsots or any other databse hosts?

kumar

[coopster]

...in terms of effective development, what should i put in a databse and what should be left in flat files or in html files...

That will be a decision you will have to make based on your site content, how often the content changes, who manages the content, how will the content be accessed, how will the content be found, etc.

...and also, if i have 1 db with a db host, can i have several tables to contain all the different sections, or do i need a new db for each section, say to contain cd info another db for receipes etc

Most hosts will create you an additional database(s) upon request (usually at an additional cost). You can, however, keep all your tables in a single database. Why not? It all depends on how you want to organize and manage the data, and, of course, who will access each section of data and how (from a different site, etc).

>>does anyone knwo of any free mysql hsots or any other databse hosts?

No, I don't. But remember, you get what you pay for...

[brucec]

Kumar,
The best way to answer your question is to ask yourself, what data will change and what will be constant.

Whatever data will change, put it in the database.

For instance, your company or web site logo will never change. So, hard code it. Your users and their passwords will often change, so put it in the database.

I hope this helps.