PHP page_acces SQL code needed!

[vikkevikz]

Hello! I erased my last database were all tables in the PHP exist for a website. Now I got a problem, my new database dont have the table "page_acces"

A Database Error Occurred
Error Number: 1054

Unknown column 'page_access' in 'field list'

SELECT `id`, page_access, nickname FROM

but if i go like this examplewebsite.no-ip.org//index.php/p/v/donate it goes direclty in to the website.

But the problem is i cant log in to my website, since i need to change the page_acces at the database, but there page_access section is not here. So i need the SQL code to put it in! Please help
Im using Xampp if you needed to know that!


Cheers / vokamas!

 

[Chris]

CREATE TABLE IF NOT EXISTS `news` (
     `id` INT NOT NULL AUTO_INCREMENT,
     `title` VARCHAR(50) DEFAULT '',
     `body` TEXT,
     `time` INT(10) DEFAULT 0,
     PRIMARY KEY (`id`)
);

 

[vikkevikz]

CREATE TABLE IF NOT EXISTS `news` (
     `id` INT NOT NULL AUTO_INCREMENT,
     `title` VARCHAR(50) DEFAULT '',
     `body` TEXT,
     `time` INT(10) DEFAULT 0,
     PRIMARY KEY (`id`)
);

Thanks you very much, it works!

 

[vikkevikz]

Another thing! On my database i cant find the page_access at account section or player sections, its not there. I need to create table? Chris got the table SQL code? Or someone else? Please