I've got 2 problems.

1. Unable to create a table due the following that comes
up?


Error

MySQL said: You have an error in your SQL syntax near ' , , ,test TEXT(10) NULL )' at line 1.

Query: CREATE TABLE peggydb( , , , ,test TEXT(10) NULL )

2. Also I put in 5 fields and keep only getting one field
to enter.

1) The problem is that you can not specify a character length for TEXT fields (they are standard 255 characters) and you need to use straight text for default values if you want to use one.

2) You need to specify a PRIMARY key field in order to show all the fields. But since you are having problems creating the table, you shouldn't see any columns/fields at all.
========================================
Buh Bye!

Cheers,
Me

Thanks, That makes sense. But now why am I only showing
2 of the fields. Example I want to have 10 fields in
my table but only get one field back.

1) DROP (delete) the table.
2) Re-create the table.

To find out about DATA FIELD TYPES, review documentation at http://www.mysql.com OR consult the built-in HELP files that come with MySQLMan. Click on HELP.

Bye.
========================================
Buh Bye!

Cheers,
Me

Ok. Let's start from the top.

I have not created the table or tables.
When clicking on create tables I put the
table name then the number of fields for
that table. Why am I only showing only 1
field instead of the number of fields that
I want to do. This doesn't make sense.