mysql create table

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
dave1909
Forum Newbie
Posts: 22
Joined: Sat Jul 25, 2009 8:56 pm

mysql create table

Post 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;");
iamngk
Forum Commoner
Posts: 50
Joined: Mon Jun 29, 2009 2:20 am

Re: mysql create table

Post 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());
dave1909
Forum Newbie
Posts: 22
Joined: Sat Jul 25, 2009 8:56 pm

Re: mysql create table

Post 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
Wolf_22
Forum Contributor
Posts: 159
Joined: Fri Dec 26, 2008 9:43 pm

Re: mysql create table

Post 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? :?
dave1909
Forum Newbie
Posts: 22
Joined: Sat Jul 25, 2009 8:56 pm

Re: mysql create table

Post by dave1909 »

seems to have worked by changing that default for me too :) thanks
Post Reply