Programming Help

Web Development



What's Here?

  • Members: 117,337
  • Replies: 431,178
  • Topics: 66,554
  • Snippets: 2,391
  • Tutorials: 630
  • Total Online: 2,152
  • Members: 67
  • Guests: 2,085

Who's Online?

Welcome to Dream.In.Code
Getting PHP Help is Easy!

Join 117,337 PHP Programmers for FREE! Ask your question and get quick answers from experts. There are 2,152 online right now! We've got more than 500 tutorials and 2,000 snippets. Join and find out why Dream.In.Code is the #1 programming help community on the internet! Registration is fast and FREE... Join Now!



Blog DB organization

 
 Reply to this topicStart new topic

Blog DB organization
musya
post 8 May, 2008 - 09:25 AM
Post #1


D.I.C Head

Group Icon
Joined: 25 Apr, 2007
Posts: 243



Thanked 1 times

Dream Kudos: 50
My Contributions
I'm making a simple blog for a site and im trying to figure out how to organize the db, each page will have a seperate blog entry space at the bottom along with peoples reviews, and i was thinking of organizing by making a row for each page and just have one column with a string array, will that work you think? since each page wont have the same amount of entries therefor i cant make each column an entry. Any opinions?
User is offlineProfile CardPM

Go to the top of the page


fyrestorm
post 8 May, 2008 - 09:30 AM
Post #2


D.I.C Lover

Group Icon
Joined: 4 Apr, 2002
Posts: 3,079



Dream Kudos: 228
My Contributions
realistically, you don't want to be storing string arrays in db fields, it's just bad design.

The best way to go about this would be to determine what fields you need for the blog entry itself and then what fields you need for the reviews and have at least 2 tables in the db that are related a primary/foreign key relationship.
User is offlineProfile CardPM

Go to the top of the page

musya
post 8 May, 2008 - 11:58 AM
Post #3


D.I.C Head

Group Icon
Joined: 25 Apr, 2007
Posts: 243



Thanked 1 times

Dream Kudos: 50
My Contributions
QUOTE(fyrestorm @ 8 May, 2008 - 09:30 AM) *

realistically, you don't want to be storing string arrays in db fields, it's just bad design.

The best way to go about this would be to determine what fields you need for the blog entry itself and then what fields you need for the reviews and have at least 2 tables in the db that are related a primary/foreign key relationship.


Great thanks
User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 10/7/08 01:34AM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live PHP Help!

PHP Tutorials

Reference Sheets

PHP Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month