Apache Friends Support Forum

I am trying to create a table inside of the "test" database that comes with PhpMyAdmin. I set up the fields and everything, but when I try to save the table a message pops up and reads "This is not a Number". I don't understand why this is happening. Here is how I have the table set up.


Field Type Length/Values Collation
----- ------ ----------------- ------------

id Varchar Utf8_unicode_ci

email Varchar 50 Utf8_unicode_ci

password Varchar 50 Utf8_unicode_ci

site Varchar Utf8_unicode_ci

logeden Int Utf8_unicode_ci


Attributes Null Default Extra
----------- ------ ---------- -------
not null auto_increment

not null 50

not null 50

null

not null



Storage Engine Collation
------------------ -------------
MyISAM utf8_unicode_ci


these are the values that I have. Any help with figuring out why I can't save this table is greatly appreciated.

It says what it means "This is not a number":

id Varchar Utf8_unicode_ci

You declared id as "auto_increment" which means, it MUST be a number (a digit), but you declared it as a string ("varchar"). You must change it to "int".

Regards
Scory

Scory thanks for the advice. I seem to not be able to get down how to exactly use phpmyadmin. Are their any good tutorials out there?

Why don't you have a look at the phpMyAdmin website?