I'm creating a new website, and I'm using PHP & mySQL for the first time to create a database website. I'm not too sure of how to start off. I've read a PHP - MySQL book, so I'm familiar with PHP and mysql syntax, etc. But the problem is that I'm not sure of what a typical database for a website looks like. If someone can give me an example to start from or point me to one. Thanks.
I've only used databases minimally with my sites. On my business site, I only use one database to keep track of my sales for xBlog. On my personal site, I do not use them at all, and on the Web Dev FAQs site, I should have used one, but did not. One of these days I'll have to go back and make a CMS for it. I have, however, used databases extensively on some of my clients sites, and for xBlogPro, which is coming soon.
However, I do use PHP includes on nearly every site that I make (all three listed above) as it makes it incredibly easy to keep navigation current across the entire site.