Need PHP help.

[Lysine]

I got a titorial of this forum for a rare value system but it is not working.

I get this error

Error during the execution of the MySQL query : Table 'hablaugh_rares.categories' doesn't exist

In the 'create_rv.php' file.

Does anyone know what the problem is?

+ rep
- Lysine

[Heinous]

A mysql database table is missing.

edit;
FTAO: Nublet who can't leave his or her name: I care about rep, why? Leave your name so I can return the favor, moron.

[Lysine]

A mysql database table is missing.

edit;
FTAO: Nublet who can't leave his or her name: I care about rep, why? Leave your name so I can return the favor, moron.

Ok, What do i have too call it and what else do i need too add?

+ Rep.

[Heinous]

It should be in the install script, but I'm not sure what columns it would need, as I don't know what ones it uses.

[Lysine]

It did not have a install script.

There was just a file with the SQL and i added it all.

[Heinous]

Then it could be a problem when the table was created.

Show me the SQL query you were to run, please.

[Lysine]

CREATE TABLE `rares` (
  `id` smallint(6) NOT NULL auto_increment,
  `title` varchar(30) NOT NULL default '',
  `category` tinyint(6) NOT NULL default '0',
  `image` varchar(100) NOT NULL default '',
  `date` varchar(20) NOT NULL default '',
  `name` varchar(255) default '',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;


CREATE TABLE `cats` (
  `id` tinyint(4) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ; 

That is the SQL

[Tomm]

CREATE TABLE `rares` (
  `id` smallint(6) NOT NULL auto_increment,
  `title` varchar(30) NOT NULL default '',
  `category` tinyint(6) NOT NULL default '0',
  `image` varchar(100) NOT NULL default '',
  `date` varchar(20) NOT NULL default '',
  `name` varchar(255) default '',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;


CREATE TABLE `cats` (
  `id` tinyint(4) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ; 

That is the SQL

It's looking for a table called "categorys" which does not exist. I am guessing it is really looking for the table called cats.

[Heinous]

It's looking for a table called "categorys" which does not exist. I am guessing it is really looking for the table called cats.

By looking at it I'd agree.

[Lysine]

How would i be able too add the table which needs too be added?