Jump to content


Photo

19 values into a database


  • Please log in to reply
3 replies to this topic

#1 Perad

Perad
  • Members
  • PipPipPip
  • Advanced Member
  • 287 posts

Posted 16 October 2006 - 10:18 AM

First i am newish to php so am mainly looking for some reassurance.

I have a massive form where the user needs to enter 19 values for a match report.

I will then have 2 pages pulling data off the database. The first page will show about 5 fields, the second will show them all. The website that i am making it for will start with low traffic then steadily rise.

Is 19 values into 1 table going to be ok? Or should i try to separate the values?

#2 Daniel0

Daniel0
  • Staff Alumni
  • Advanced Member
  • 11,956 posts

Posted 16 October 2006 - 10:56 AM

I guess it would be fine to store it in one table, but it depends on what they are entering.

#3 Ninjakreborn

Ninjakreborn
  • Members
  • PipPipPip
  • Information Technology Specialist
  • 3,922 posts
  • Age:33

Posted 21 October 2006 - 05:18 PM

You can have as many in one table as you want, or split up throughout as many table's as you want.  Eventually you run into problem's if it's not organized, but keep it organized, use common sense.  And you should be fine.

------

Business Website: http://www.infotechnologist.biz

Personal Website: http://www.joyelpuryear.com

Blog Site: http://www.realmofwriting.com
Services: Web development, application development, mobile development, and custom development. All services listed on my website.


#4 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,021 posts

Posted 22 October 2006 - 10:14 AM

Despite its name, common sense can be a rare commodity. The number of tables you use should be dictated by relationships between the data items and the rules of data normalization.
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users