To edit delete just go to phpmyadmin znote_news table..
But I want and I need to be able to do it from the website because I have other people that got to be able to do that...
To edit delete just go to phpmyadmin znote_news table..
Table 'otserv.znote_news' doesn't exist
CREATE TABLE IF NOT EXISTS `znote_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(20) NOT NULL,
`body` text NOT NULL,
`date` date NOT NULL,
`author` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;
go to localhost/phpmyadmin
select your database, click on the SQL tab
paste this
PHP:CREATE TABLE IF NOT EXISTS `znote_news` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(20) NOT NULL, `body` text NOT NULL, `date` date NOT NULL, `author` varchar(30) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;
and enter it,
Take a look at your database znote_news table, maybe you are using the now integrated znote news system
same...No changelogs submitted.string(165) "SELECT `n`.`id`, `n`.`title`, `n`.`text`, `n`.`date`, `p`.`name` FROM `znote_news` AS `n` INNER JOIN `players` AS `p` ON `n`.`pid` = `p`.`id` ORDER BY `n`.`id` DESC;"
(query - SQL error)
Type: select_multi (select multiple rows from database)
Unknown column 'n.text' in 'field list'
Row n.text do not exist.same...