mysql problem

[Dumeko]

when i start a server it starts up but then is spamed by



mysql_real_querry(): select * from z_ots_comunication = 'login'; - mysql error: table 'noobwar.z_ots_communication' doesnt 6)

taking it means that my database doesnt have this table? how do i add it or where should i add it

thanks for the help

 

[Zakhran]

CREATE TABLE `noobwar.z_ots_communication`

as a sql query in your phpMyAdmin

 

[Dumeko]

yeh, i know its in my phpmyadmin, but i do not know what to create it under, oh create a new table

dunno how to create a new table....let me play around with it xD

 

[Dumeko]

ok i can create a new table, but how do i know what to fill it out as




Field
Type
Length/Values1
Default2


Collation
Attributes
Null
Index
AUTO_INCREMENT
Comments
MIME type
Browser transformation
Transformation options3

 

[Cornwallis]

at the top left corner of the page on phpmyadmin, there is a little link that says SQL, and when you hover over it it says query window, press that and execute this

CREATE TABLE `z_ots_comunication` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `param1` varchar(255) NOT NULL,
  `param2` varchar(255) NOT NULL,
  `param3` varchar(255) NOT NULL,
  `param4` varchar(255) NOT NULL,
  `param5` varchar(255) NOT NULL,
  `param6` varchar(255) NOT NULL,
  `param7` varchar(255) NOT NULL,
  `delete_it` int(2) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

 

[Dumeko]

thanks, now if you could kindly point me in the direction to rep++ you xD