Table creation

[natalieG]

can someone tell me why these two queries for generating tables dot execute properly?
Thankss,
Jennifer

$CONTACT_QUERY="CREATE TABLE ATMELPIM_CONTACT(
CONTACT_INDEX INTEGER,
CONTACT_ENTRYDATE INTEGER,
CONTACT_DATESTR VARCHAR(20),
CONTACT_REP VARCHAR(20),
CONTACT NAME VARCHAR(40),
CONTACT_PROJECT VARCHAR(25),
CONTACT_ADDRESS1 VARCHAR(50),
CONTACT_ADDRESS2 VARCHAR(50),
CONTACT_CITY VARCHAR(50),
CONTACT_STATE VARCHAR(10),
CONTACT_ZIPCODE VARCHAR(12),
CONTACT_PHONE VARCHAR(20),
CONTACT_EXTENSION VARCHAR(10)
)";

$NOTE_QUERY= "CREATE TABLE ATMELPIM_NOTES(
NOTE_INDEX INTEGER,
NOTE_ENTRYDATE INTEGER,
NOTE_DATESTR varchar(20),
NOTE_COMPANY VARCHAR($FIELD_LENGTH),
NOTE_CONTACT_NAME VARCHAR(40),
NOTE_TEXT VARCHAR(8192)
)";

[litebearer]

May be an obvious question, but did you connect to the database AND execute the query? Perhaps a little more of your code would help.

Lite...

[Barand]

Or it could be that the account you are using to connect does not have CREATE privileges.

Although in your 2nd query you probably get an error as varchar has a max length of 255. Use TEXT type.