Erro Syntax db site

[Scofield]

Hello I have a website a bit old, you need a database but the db be giving error in the current managers,

 

if someone podesse fix I would be very grateful

 

 

Erro: #1064 - You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near 'mysql_query("CREATE DATABASE `site_alan`")' at line 1

 

 

 

mysql_query("CREATE DATABASE `site_alan`");
    
    mysql_query("CREATE TABLE `site_alan`.`fama` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`foto` VARCHAR( 100 ) NOT NULL ,
`nome` VARCHAR( 100 ) NOT NULL ,
`nick` VARCHAR( 100 ) NOT NULL ,
`classe` VARCHAR( 100 ) NOT NULL ,
`cla` VARCHAR( 100 ) NOT NULL ,
`idade` VARCHAR( 100 ) NOT NULL ,
`mora` VARCHAR( 100 ) NOT NULL
) ENGINE = MYISAM");

    mysql_query("CREATE TABLE `site_alan`.`regras` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`regra` TEXT NOT NULL
) ENGINE = MYISAM");

    mysql_query("CREATE TABLE `site_alan`.`download` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`versao_pat` VARCHAR( 50 ) NOT NULL ,
`tamanho_pat` VARCHAR( 50 ) NOT NULL ,
`link_pat` TEXT NOT NULL ,
`episodio_bro` VARCHAR( 50 ) NOT NULL ,
`tamanho_bro` VARCHAR( 50 ) NOT NULL ,
`link_bro` TEXT NOT NULL
) ENGINE = MYISAM");

    mysql_query("CREATE TABLE `site_alan`.`equipe` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`cargo` VARCHAR( 50 ) NOT NULL ,
`nome` VARCHAR( 50 ) NOT NULL ,
`especi` TEXT NOT NULL
) ENGINE = MYISAM");

    mysql_query("CREATE TABLE `site_alan`.`noticias` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`titulo` TEXT NOT NULL ,
`noticia` TEXT NOT NULL ,
`data` VARCHAR( 20 ) NOT NULL ,
`por` VARCHAR( 50 ) NOT NULL
) ENGINE = MYISAM");


    mysql_query("CREATE TABLE `site_alan`.`eventos` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`titulo` TEXT NOT NULL ,
`evento` TEXT NOT NULL ,
`data` VARCHAR( 20 ) NOT NULL
) ENGINE = MYISAM");

    mysql_query("CREATE TABLE `site_alan`.`admin` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`usuario` VARCHAR( 50 ) NOT NULL ,
`senha` VARCHAR( 50 ) NOT NULL ,
`privilegio` VARCHAR( 2 ) NOT NULL
) ENGINE = MYISAM");

Edited August 29, 2013 by cumbe11

[Capuche]

CREATE DATABASE `site_alan`;
    
CREATE TABLE `site_alan`.`fama` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`foto` VARCHAR( 100 ) NOT NULL ,
`nome` VARCHAR( 100 ) NOT NULL ,
`nick` VARCHAR( 100 ) NOT NULL ,
`classe` VARCHAR( 100 ) NOT NULL ,
`cla` VARCHAR( 100 ) NOT NULL ,
`idade` VARCHAR( 100 ) NOT NULL ,
`mora` VARCHAR( 100 ) NOT NULL
) ENGINE = MYISAM;

CREATE TABLE `site_alan`.`regras` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`regra` TEXT NOT NULL
) ENGINE = MYISAM;

CREATE TABLE `site_alan`.`download` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`versao_pat` VARCHAR( 50 ) NOT NULL ,
`tamanho_pat` VARCHAR( 50 ) NOT NULL ,
`link_pat` TEXT NOT NULL ,
`episodio_bro` VARCHAR( 50 ) NOT NULL ,
`tamanho_bro` VARCHAR( 50 ) NOT NULL ,
`link_bro` TEXT NOT NULL
) ENGINE = MYISAM;

CREATE TABLE `site_alan`.`equipe` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`cargo` VARCHAR( 50 ) NOT NULL ,
`nome` VARCHAR( 50 ) NOT NULL ,
`especi` TEXT NOT NULL
) ENGINE = MYISAM;

CREATE TABLE `site_alan`.`noticias` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`titulo` TEXT NOT NULL ,
`noticia` TEXT NOT NULL ,
`data` VARCHAR( 20 ) NOT NULL ,
`por` VARCHAR( 50 ) NOT NULL
) ENGINE = MYISAM;


CREATE TABLE `site_alan`.`eventos` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`titulo` TEXT NOT NULL ,
`evento` TEXT NOT NULL ,
`data` VARCHAR( 20 ) NOT NULL
) ENGINE = MYISAM;

CREATE TABLE `site_alan`.`admin` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`usuario` VARCHAR( 50 ) NOT NULL ,
`senha` VARCHAR( 50 ) NOT NULL ,
`privilegio` VARCHAR( 2 ) NOT NULL
) ENGINE = MYISAM;

You forgot to remove ")  of mysql_query

) ENGINE = MYISAM");

[Capuche]

Remove the mysql_query(", like that

CREATE DATABASE `site_alan`;

same about the tables

[Scofield]

Thanks for answering Capuche, I put that way and gave the following error.

 

Erro: #1064 - You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near '");



CREATE TABLE `regras` (

`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,

' at line 10

 

CREATE TABLE `fama` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`foto` VARCHAR( 100 ) NOT NULL ,
`nome` VARCHAR( 100 ) NOT NULL ,
`nick` VARCHAR( 100 ) NOT NULL ,
`classe` VARCHAR( 100 ) NOT NULL ,
`cla` VARCHAR( 100 ) NOT NULL ,
`idade` VARCHAR( 100 ) NOT NULL ,
`mora` VARCHAR( 100 ) NOT NULL
) ENGINE = MYISAM");

CREATE TABLE `regras` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`regra` TEXT NOT NULL
) ENGINE = MYISAM");

CREATE TABLE `download` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`versao_pat` VARCHAR( 50 ) NOT NULL ,
`tamanho_pat` VARCHAR( 50 ) NOT NULL ,
`link_pat` TEXT NOT NULL ,
`episodio_bro` VARCHAR( 50 ) NOT NULL ,
`tamanho_bro` VARCHAR( 50 ) NOT NULL ,
`link_bro` TEXT NOT NULL
) ENGINE = MYISAM");

CREATE TABLE `equipe` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`cargo` VARCHAR( 50 ) NOT NULL ,
`nome` VARCHAR( 50 ) NOT NULL ,
`especi` TEXT NOT NULL
) ENGINE = MYISAM");

CREATE TABLE `noticias` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`titulo` TEXT NOT NULL ,
`noticia` TEXT NOT NULL ,
`data` VARCHAR( 20 ) NOT NULL ,
`por` VARCHAR( 50 ) NOT NULL
) ENGINE = MYISAM");


CREATE TABLE `eventos` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`titulo` TEXT NOT NULL ,
`evento` TEXT NOT NULL ,
`data` VARCHAR( 20 ) NOT NULL
) ENGINE = MYISAM");

CREATE TABLE `admin` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`usuario` VARCHAR( 50 ) NOT NULL ,
`senha` VARCHAR( 50 ) NOT NULL ,
`privilegio` VARCHAR( 2 ) NOT NULL
) ENGINE = MYISAM");

[Scofield]

Tranks.