I want to create a blog script using PHP and MySql. I know that there are many other ready made blog scripts available, but I intent to create it myself for educational purpose. So if any body guide me to such website which has useful tips related to my query. Thanks.
Download WordPress and go through their code. Take a look at their database structure it's really good. Build your's accordingly. You may not need all the fields they have though.
I don't think that wordpress database is really for a beginner but it is the best blog platform you should read this ... all 3 pages = 12 steps good info http://codegrrl.com/category/tutorials/build-a-blog/page/3