Page 1 of 1

mysql create table

Posted: Mon Aug 03, 2009 8:19 pm
by dave1909
can anybody tell me whats wrong with this? no matter what i change it wont seem to work. all the other tables in this page are created, this is the only one that isnt so i've narrowed it down. thanks in advance

Code: Select all

mysql_query("CREATE TABLE `r$round[0]_crew` (
  `id` int(6) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `founder` varchar(255) NOT NULL default '',
  `members` smallint(6) NOT NULL default '1',
  `profile` varchar(255) NOT NULL default '',
  `icon` varchar(255) NOT NULL default '',
  `rank` decimal(65,0) unsigned NOT NULL default '99999',
  `networth` decimal(65,0) unsigned NOT NULL default '0',
  `cofounder` varchar(255) NOT NULL default '',
  `accept` varchar(255) NOT NULL default 'No',
  `base` tinyint(3) NOT NULL default '',
  `soldiers` tinyint(3) NOT NULL default '2',
  `points` tinyint(3) NOT NULL default '2',
  `crewpoints` decimal(65,0) NOT NULL default '0',  
 `joined` int(12) unsigned NOT NULL default '0',
  `advisor1` varchar(255) NOT NULL default '',
  `advisor2` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;");

Re: mysql create table

Posted: Mon Aug 03, 2009 11:01 pm
by iamngk
what error php returns when executing the query.

use mysql_error method to identify that.

syntex

mysql_query("Your create query will come here") or die(mysql_error());

Re: mysql create table

Posted: Mon Aug 03, 2009 11:12 pm
by dave1909
I put that in and it didnt give an error :? it just creates all the other tables but still not that one

I've tried to do an sql query in phpmyadmin and got this:

Error

SQL query:

mysql_query(
"CREATE TABLE `r29_crew` ( `id` int(6) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `founder` varchar(255) NOT NULL default '', `members` smallint(6) NOT NULL default '1', `profile` varchar(255) NOT NULL default '', `icon` varchar(255) NOT NULL default '', `rank` decimal(65,0) unsigned NOT NULL default '99999', `networth` decimal(65,0) unsigned NOT NULL default '0', `cofounder` varchar(255) NOT NULL default '', `accept` varchar(255) NOT NULL default 'No', `base` tinyint(3) NOT NULL default '', `soldiers` tinyint(3) NOT NULL default '2', `points` tinyint(3) NOT NULL default '2', `crewpoints` decimal(65,0) NOT NULL default '0', `joined` int(12) unsigned NOT NULL default '0', `advisor1` varchar(255) NOT NULL default '', `advisor2` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM;"
)

MySQL said: Documentation
#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 TABLE `r29_crew` (
`id` int(6) unsigned NOT NULL auto_inc' at line 1

Re: mysql create table

Posted: Mon Aug 03, 2009 11:59 pm
by Wolf_22
Sorry if I'm speaking out of turn or experience here, but I tried the following and it works (the only exception is that I modified your default in 'base' to be a zero (http://dev.mysql.com/doc/refman/5.0/en/ ... aults.html):

Code: Select all

                $result = mysql_query(
                    "CREATE TABLE `r29_crew` ( 
                        `id` int(6) unsigned NOT NULL auto_increment, 
                        `name` varchar(255) NOT NULL default '', 
                        `founder` varchar(255) NOT NULL default '', 
                        `members` smallint(6) NOT NULL default '1', 
                        `profile` varchar(255) NOT NULL default '', 
                        `icon` varchar(255) NOT NULL default '', 
                        `rank` decimal(65,0) unsigned NOT NULL default '99999', 
                        `networth` decimal(65,0) unsigned NOT NULL default '0', 
                        `cofounder` varchar(255) NOT NULL default '', 
                        `accept` varchar(255) NOT NULL default 'No', 
                        `base` tinyint(3) NOT NULL default '0', 
                        `soldiers` tinyint(3) NOT NULL default '2', 
                        `points` tinyint(3) NOT NULL default '2', 
                        `crewpoints` decimal(65,0) NOT NULL default '0', 
                        `joined` int(12) unsigned NOT NULL default '0', 
                        `advisor1` varchar(255) NOT NULL default '', 
                        `advisor2` varchar(255) NOT NULL default '', 
                        PRIMARY KEY (`id`) ) TYPE=MyISAM;"
                    );
 
                if (!$result) {
                    die('Invalid query: ' . mysql_error());
                }
If it works, great. If not, once again, sorry. Anyone else have any ideas? :?

Re: mysql create table

Posted: Tue Aug 04, 2009 12:13 am
by dave1909
seems to have worked by changing that default for me too :) thanks