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,
coppauser smallint(6) DEFAULT '0' NOT NULL,
homepage varchar(100) NOT NULL,
icq varchar(20) NOT NULL,
aim varchar(20) NOT NULL,
yahoo varchar(20) NOT NULL,
biography mediumtext NOT NULL,
signature mediumtext NOT NULL,
adminemail smallint(6) DEFAULT '0' NOT NULL,
showemail smallint(6) DEFAULT '0' NOT NULL,
invisible smallint(6) DEFAULT '0' NOT NULL,
usertitle varchar(250) NOT NULL,
customtitle smallint(6) DEFAULT '0' NOT NULL,
joindate int(10) unsigned DEFAULT '0' NOT NULL,
canpost smallint(6) DEFAULT '0' NOT NULL,
cookieuser smallint(6) DEFAULT '0' NOT NULL,
daysprune smallint(6) DEFAULT '0' NOT NULL,
lastvisit int(10) unsigned DEFAULT '0' NOT NULL,
lastactivity int(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' NOT NULL,
imgurl varchar(150) NOT NULL,
PRIMARY KEY (userid),
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 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 key no matter what. And it
makes two date fields I enter NULL and the rest NOT
NULL no matter what I put in the checkboxes. The code
is below along with a printout of the SQL query. I only
wanted suffix and death date to be null. This is combination
from PHP Fast and Easy and MySQL by Dubois.
$sql = "CREATE TABLE $table_name (";
for ($i = 0; $i < count($field_name); $i++) {
$sql .= "$field_name[$i] $field_type[$i]";
if ($not_null[$i] == "Y") {
$additional = " NOT NULL";
} else {
$additional = " NULL";
}
if ($auto_increment[$i] == "Y") {
$additional .= " AUTO_INCREMENT";
} else {
$additional .= "";
}
if ($primary[$i] == "Y") {
$additional .= " primary key";
} else {
$additional .= "";
}
if ($field_length[$i] != "") {
$sql .= "($field_length[$i]) $additional,";
} else {
$sql .= " $additional,";
}
}
$sql = substr($sql, 0, -1);
$sql .= ")";
------------
CREATE TABLE president (last_name varchar(15) NOT NULL primary
key,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 date NULL)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
