RE: [PHP] MySQL Create Table Problem

I found where the problem stems from after correcting a couple items per your example but still don't know why it won't work. It comes from using checkboxes in the form for PRIMARY KEY, AUTO_INCREMENT and NOT NULL or NULL. When I use checkboxes like this: it totally messes up the query. But

RE: [PHP] MySQL Create Table Problem

Quick example... CREATE TABLE user ( userid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, usergroupid smallint(5) unsigned DEFAULT '0' NOT NULL, username varchar(50) NOT NULL, password varchar(50) NOT NULL, email varchar(50) NOT NULL, parentemail varchar(50) NOT NULL,

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