[RESOLVED] Create Table error

[cisforcasey]

Hi,

Can someone please tell me what's wrong with this query? I've looked at a number of threads and I can't figure out what is wrong with my syntax. Thanks

$sql = "CREATE TABLE test (
ID int( 11 ) NOT NULL auto_increment,
fname varchar( 20 ) default NOT NULL, 
lname varchar( 30 ) default NOT NULL, 
address varchar( 80 ) default NOT NULL , 
zipcode varchar( 5 ) default NOT NULL ,
watershed char( 2 ) default NOT NULL ,
lat float( 10, 6 ) default NOT NULL default 0.000000,
lng float( 10, 6 ) default NOT NULL default 0.000000,
phone varchar( 10 ) default  NOT NULL ,
email varchar( 30 ) default NOT NULL ,
btype varchar( 13 ) default  NOT NULL ,
downspout int( 11 ) default NOT NULL , 
wateruse text NOT NULL default,
refer text NOT NULL default,
rights char( 3 ) NOT NULL default, 
org varchar( 100 ) NOT NULL default, 
PRIMARY KEY ( ID )) ENGINE=InnoDB DEFAULT CHARSET=utf8;"; 

Here is the error message I'm getting:

Invalid query: 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 'NOT NULL, lname varchar( 30 ) default NOT NULL, address varchar( 80 ) default ' at line 3

[pete_bisby]

Although you have specified "default" for each field, you haven't specified an actual default value.

Place a default value after "default" keyword and the table creation should be successful.

[cisforcasey]

Great! That worked. Thanks for your help.

Perhaps you can help me with another problem. I'd like the tables to be names dynamically, so I set up a string that is part based off variables and part based off text:

$table_name = $watershed + "" + $date + "signup_list";

However, I'm having trouble getting this to work. It seems to just take the date field. I'm pretty new to PHP, and I haven't figured out to work with strings all that well yet. Thanks

• Casey

[pete_bisby]

To concatenate strings together, you need to use a full stop/period

$table_name = ($watershed . "_" . $date . "_signup_list");

Using plus signs is javascript/java/microsoft - PHP is more C/C++ based.

[cisforcasey]

great, that worked. thanks a lot for your help.

• Casey