[eluser]Sawariya[/eluser]
syntax error, unexpected '%' in E:\xampp\htdocs\......\system\application\models\archivesmodel.php on line 60
Table syntax
CREATE TABLE `users` (
`user_id` int(11) NOT NULL auto_increment,
`group_id` int(1) NOT NULL,
`category` enum('agencies','models','photographers') collate latin1_general_ci NOT NULL,
`email_id` varchar(100) collate latin1_general_ci NOT NULL,
`password` varchar(32) collate latin1_general_ci NOT NULL,
`salt` varchar(5) collate latin1_general_ci NOT NULL,
`display_name` varchar(100) collate latin1_general_ci NOT NULL,
`profilepic` varchar(100) collate latin1_general_ci NOT NULL,
`dob` date NOT NULL,
`model_type` enum('male','female','children','agencies') collate latin1_general_ci NOT NULL,
`address` varchar(100) collate latin1_general_ci NOT NULL,
`city` varchar(50) collate latin1_general_ci NOT NULL,
`state` varchar(50) collate latin1_general_ci NOT NULL,
`country` varchar(50) collate latin1_general_ci NOT NULL,
`zipcode` varchar(20) collate latin1_general_ci NOT NULL,
`oftheweek` enum('published','unpublished') collate latin1_general_ci NOT NULL default 'unpublished',
`created_on` datetime NOT NULL,
`activation_date` datetime NOT NULL,
`last_login` datetime NOT NULL,
`verification` varchar(20) collate latin1_general_ci NOT NULL,
`status` enum('active','inactive','deleted') collate latin1_general_ci NOT NULL default 'inactive',
`top_models` enum('active','inactive','notyet') collate latin1_general_ci NOT NULL default 'notyet',
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=28 ;