<? include "config.php"; $criar_tabela = mysql_query(" CREATE TABLE perfil ( id INT( 25 ) NOT NULL AUTO_INCREMENT , uid VARCHAR( 75 ) NOT NULL , member_id INT( 25 ) NOT NULL, relacionamento TEXT NOT NULL , aniversario TEXT NULL , view_mail INT( 1 ) NOT NULL , animais TEXT NOT NULL , site TEXT NOT NULL , cidade TEXT NOT NULL , estado TEXT NOT NULL, pais TEXT NOT NULL, views INT( 75 ) NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM;", $db); $criar_tabelaa = mysql_query(" CREATE TABLE perfil_animais ( id INT( 25 ) NOT NULL AUTO_INCREMENT , uid VARCHAR( 75 ) NOT NULL , member_id INT( 25 ) NOT NULL, nome TEXT NOT NULL , aniversario TEXT NULL , adora TEXT NOT NULL , odeia TEXT NOT NULL , sexo TEXT NOT NULL , cidade TEXT NOT NULL, estado TEXT NOT NULL, pais TEXT NOT NULL, views INT( 75 ) NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM;", $db); $criar_tabelaaa = mysql_query(" CREATE TABLE maximo ( quantidade int(7) NOT NULL default '1', data date NOT NULL default '0000-00-00', hora time NOT NULL default '00:00:00' ) TYPE=MyISAM;", $db); $criar_tabelaaaa = mysql_query(" CREATE TABLE usersonline ( id int(7) NOT NULL auto_increment, ip varchar(255) NOT NULL default '', TIME int(12) NOT NULL default '0', local varchar(255) NOT NULL default '', user_id varchar(50) NOT NULL default '', ) TYPE=MyISAM;", $db); if ( $criar_tabela == 1 ) { echo "Tabela de perfis criada com sucesso.<br />"; } else { echo mysql_error($db); } if ( $criar_tabelaa == 1 ) { echo "Tabela de perfis animais criada com sucesso.<br />"; } else { echo mysql_error($db); } if ( $criar_tabelaaa == 1 ) { echo "Tabela de maximo criada com sucesso.<br />"; } else { echo mysql_error($db); } if ( $criar_tabelaaaa == 1 ) { echo "Tabela de online criada com sucesso.<br />"; } else { echo mysql_error($db); } mysql_query("INSERT INTO `maximo` VALUES (1, '2005-06-04', '09:00:00');"); ?>O erro que ele retorna é:
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 ') TYPE=MyISAM' at line 7You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') TYPE=MyISAM' at line 7You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') TYPE=MyISAM' at line 7You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') TYPE=MyISAM' at line 7
E eu não consigo arrumar =S
O que está errado?