RE: [PHP] MySQL Create Table Problem

t(10) unsigned DEFAULT '0' NOT NULL, >lastpost int(10) unsigned DEFAULT '0' NOT NULL, >posts smallint(5) unsigned DEFAULT '0' NOT NULL, >timezoneoffset smallint(6) DEFAULT '0' NOT NULL, >emailnotification smallint(6) DEFAULT '0&#x

RE: [PHP] MySQL Create Table Problem

), KEY idxgroups (username, usergroupid) ); -Original Message- From: Jeff Oien [mailto:[EMAIL PROTECTED]] Sent: Friday, March 02, 2001 2:09 PM To: PHP Subject: [PHP] MySQL Create Table Problem This is driving me nuts. I really tried to figure it out myself. I have a form for creating a

Re: [PHP] MySQL Create Table Problem

Shouldn't the primary key spec come at the end of the table create command, not in the middle ex... CREATE TABLE president ( last_name varchar(15) NOT NULL, first_name varchar(15) NOT NULL, suffix varchar(5) NOT NULL, city varchar(20) NOT NULL, state varchar(2) NOT NULL, birth date NULL, death da

[PHP] MySQL Create Table Problem

This is driving me nuts. I really tried to figure it out myself. I have a form for creating a table. The form fields have field_name field_type field_length, and checkboxes for not_null, auto_increment and primary. When I check the primary key checkbox it always makes the first field the primary