Mysql error table

[gizzzmo]

It says this; "mysql_real_query<>: SELECT * FROM z_ots_comunication WHERE 'type' = 'login'; - MYSQL ERROR: Table '*****.z_ots_comunication' doesn't exist' <1146>

I understand I have to add this table in the database, but I need help on it. If you can help I would appreciate it.

Thanks.

 

[Gramwsloneczko]

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;

rep++

 

[gizzzmo]

I Rep'd you.

But sorry for being noob, but when I go to my database and I go to the bottom where it says "create new table on databse" underneath it I put "z_ots_comunication" then it asks for number of fields, I put 1. The I click go and something like this pops up (Not sure if i'm doing this correctly)


Field _____
Type VARCHAR _____
Length/Values1 _____
Collation
Attributes _____
Null _____
Default2 _____

CURRENT_TIMESTAMP
Extra _____



---

Comments _____
MIME type _____
Transformation options3 _____

 

[Gramwsloneczko]

go to SQL and then paste what I copy to you..