I am new to all this and have been trying to figure out how to do a gaming review database, where users can enter information into a form and saved into a mySQL database and displayed in a html page. Also the users need to be able to view all the reviews. The sections that are to be entered information into are as follows:

Each section containing 2-3 paragraphs.

Introduction

History of the game, prequels, developer information, basic story

Game design 1-10pts

Type of game, layout, single/multi-player, live(?), quality of production, character depth, etc.

Game Play 1-10pts

Controls, interaction, AI, game feel, etc.

Graphics 1-10pts

Difficulty 1-10pts

Replay Value 1-10pts

Synopsis

Grade out of 10, not an average

Listing of similar games

Any help that anyone can give me on this would be greatly appreciated. I know that this is quite a big project for someone of my lack of skill to attack but I have no choice.

    id (int) not null auto_increment
    intro (text) not null
    design (int) not null
    design_info (text) not null
    gplay (int) not null
    gplay_info (text) not null
    graphics (int) not null
    difficulty (int) not null
    replay (int) not null
    synopsis (text) not null
    grade (int) not null
    similar (text) not null

    Unique ID = id

    That would be your table setup. Then just run basic queries to insert, update, or view information.

    ~Brett

      bpat1434 wrote:

      id (int) not null auto_increment
      intro (text) not null
      design (int) not null
      design_info (text) not null
      gplay (int) not null
      gplay_info (text) not null
      graphics (int) not null
      difficulty (int) not null
      replay (int) not null
      synopsis (text) not null
      grade (int) not null
      similar (text) not null

      Unique ID = id

      That would be your table setup. Then just run basic queries to insert, update, or view information.

      ~Brett

      Do I create the tables in php? Like I said I am really a novice in this area.

        You create a table inside of a database. There are plenty out there to choose from. There is plenty of debate about which database to use, and which version. Current choices are:

        mySQL 4.x
        mySQL 5.x

        PostgreSQL

        MSSQL

        MS ODBC

        It's really a matter of what you want. mySQL is open source (as is PostgreSQL), and you can do different things with each. mySQL is probably the most used "newbie" database. Your host probably has mySQL up and running, and you can create users and databases via your cPanel. From there, you'd need to use phpMyAdmin (www.phpmyadmin.net) or straight php & mySQL code to create your tables.

        phpMyAdmin creates a nice GUI for you to see what it is you're doing, and to also help you create some basic PHP code to work with. phpMyAdmin is by no means the best way to learn mySQL syntax or usage, but it is a stepping stone.

        If you're using a shared host (www.hostgator.com www.hostrocket.com www.ixwebhosting.com) then mySQL is pre-configured, and you just need to create the user(s) and database(s) and then log in to phpMyAdmin. That link can be found from within your cPanel.

        ~Brett

          bpat1434 wrote:

          You create a table inside of a database. There are plenty out there to choose from. There is plenty of debate about which database to use, and which version. Current choices are:

          mySQL 4.x
          mySQL 5.x

          PostgreSQL

          MSSQL

          MS ODBC

          It's really a matter of what you want. mySQL is open source (as is PostgreSQL), and you can do different things with each. mySQL is probably the most used "newbie" database. Your host probably has mySQL up and running, and you can create users and databases via your cPanel. From there, you'd need to use phpMyAdmin (www.phpmyadmin.net) or straight php & mySQL code to create your tables.

          phpMyAdmin creates a nice GUI for you to see what it is you're doing, and to also help you create some basic PHP code to work with. phpMyAdmin is by no means the best way to learn mySQL syntax or usage, but it is a stepping stone.

          If you're using a shared host (www.hostgator.com www.hostrocket.com www.ixwebhosting.com) then mySQL is pre-configured, and you just need to create the user(s) and database(s) and then log in to phpMyAdmin. That link can be found from within your cPanel.

          ~Brett

          I did what you said and i am getting this error, is it possible that there is already a key column set as a default?

          Error
          SQL-query:

          CREATE TABLE Game Reviews (

          ID INT NOT NULL AUTO_INCREMENT ,
          Intro TEXT NOT NULL ,
          Design INT NOT NULL ,
          Design_info TEXT NOT NULL ,
          Gplay INT NOT NULL ,
          Gplay_info TEXT NOT NULL ,
          Graphics INT NOT NULL ,
          Difficulty INT NOT NULL ,
          Replay INT NOT NULL ,
          Synopsis TEXT NOT NULL ,
          Grade INT NOT NULL ,
          Similar TEXT NOT NULL
          )
          MySQL said:

          #1075 - Incorrect table definition; There can only be one auto column and it must be defined as a key

            Never mind I actually figured it out on my own. I didn't set the ID field to primary. I really appreciate all the help.

              Write a Reply...