HELP! I can't even create a table!

[Down Under Dan]

<NEWBIE>
Hi all!

I keep getting a parse error when I try to CREATE a TABLE. I am using mySQL
run on a LINUX box. The error is in the line about CREATE TABLE.

I just can't see what I am doing wrong - do you have a hint?

Here is the code:

#Opening Database link
$link = mysql_connect ("localhost", "dan", "secret")
or die ("Could not connect to Database.");
$result = mysql_list_tables ("dansdatabase");

# --------------------------------------------------------
#
# 'users'
#

CREATE TABLE users (
Username longtext NOT NULL,
Password longtext NOT NULL,
AccessLevel longtext NOT NULL,
IP longtext NOT NULL
);

#
# 'users'
#

INSERT INTO users VALUES( 'Franz', 'dog', '1', '');
INSERT INTO users VALUES( 'Esther', 'cat', '2', '');
INSERT INTO users VALUES( 'Dan', 'cow', '3', '');

[Down Under Dan]

SORRY!

I thought that I was posting to the php newsgroup.

"Down Under Dan" <pola...@hotmail.com> skrev i en meddelelse
news:3bea6291$0$210$edfa...@dspool01.news.tele.dk...