Author Topic: Making Seperate Databases  (Read 1379 times)

0 Members and 1 Guest are viewing this topic.

Offline !!!!!Topic starter

  • Enthusiast
  • Posts: 68
    • View Profile
Making Seperate Databases
« on: December 22, 2006, 06:18:57 PM »
I need help with making seperate databases...

I have a fansite/helpsite for a multi-player game called Runescape. This game has items, monsters, and people. I would like to make a seperate database (and a search bar so people can search for an item/monster/person) for each of these. Things... How can I do this?

Also, how do I make a search bar for the database? Incase I am mistaken about sites having multiple database, here is an example of what I mean: Scroll down and you will see Monsters, People, and Items.
http://runehq.com

Last but not least, how do I access my MySQL database through vDeck?

I am a total newbie PHPer and if anybody doesn't want to write any long strips of code but do want to help you can just post a URL for me. :-)

Offline thorpe

  • Administrator
  • 'Mind Boggling!'
  • *
  • Posts: 29,255
    • View Profile
Re: Making Seperate Databases
« Reply #1 on: December 22, 2006, 06:34:35 PM »
You dont make a seperate database for each item. Maybe a seperate table, but even that depends. You really need to find some tutorials on database design and in particular database normalization.

We can help with your design but you would at least need to make a start on it. Database design concepts can be quite in depth and really need to be carried out by someone who knows the data and the search criteria. ie; You.

Offline thorpe

  • Administrator
  • 'Mind Boggling!'
  • *
  • Posts: 29,255
    • View Profile
Re: Making Seperate Databases
« Reply #2 on: December 22, 2006, 06:37:42 PM »
Looking at your example, that Person database is actually just a table.

Offline !!!!!Topic starter

  • Enthusiast
  • Posts: 68
    • View Profile
Re: Making Seperate Databases
« Reply #3 on: December 22, 2006, 08:19:03 PM »
What do you mean by a table? Are you talking about the website-search engine or the items that you find when you search the search engine ie; the monsters, items, and people

Offline thorpe

  • Administrator
  • 'Mind Boggling!'
  • *
  • Posts: 29,255
    • View Profile
Re: Making Seperate Databases
« Reply #4 on: December 22, 2006, 08:53:02 PM »
Quote
What do you mean by a table?

Honestly, with questions like that you are long way from making anything with php/mysql. Databases store tables, tables store fields and fields store data.

This introduction will walk you through database concepts all the way to using databases with php. I suggest you read that entire section, then come back when you have more questions.