Re: phpMyAdmin

Could be something like.. Field: keynum Type: BIGINT Length/Values: (blank) Attributes: (blank) Null: NOT NULL Default: (blank) Extra: AUTO_INCREMENT Primary: CHECKED Index: CHECKED Unique: CHECKED Field: username Type: VARCHAR Length/Values: 20 Attributes: (blank) Null: NOT NULL Default: (blank) Extra: (blank) Primary: UNCHECKED Index: UNCHECKED Unique: UNCHECKED Field: password Type: VARCHAR Length/Values: 20 Attributes: (blank) Null: NOT NULL Default: (blank) Extra: (blank) Primary: UNCHECKED Index: UNCHECKED Unique: UNCHECKED Note I prefer to use VARCHAR instead of PASSWORD becuase I am more comfortable checking the database contents in PHP rather than SQL. But you can do a PASSWORD field then in your query statment use the SQL funciton PASSWORD($pwd) to encrypt the string. Either way, for security, it is imparative that you encrypt it. The field 'keynum' is just a standard thing that I do. It's set up to auto_increment so you always have a unique key to delete and update records on. For more information view the SQL documentation on www.mysql.com. Hope this helps! -Kevin ----- Original Message ----- From: "Rodrigo" <tagzero@tagzero.com> To: <php-general@lists.php.net> Sent: Friday, May 03, 2002 10:18 AM Subject: [PHP] phpMyAdmin > Hi guys, I need some help using the phpMyAdmin, I'm trying to create a > table with three fields, one for the indexing of the database, the > second for the logins and the third for the password. > > I get the following doubts: > > On the table of the phpMyAdmin there are the following fields: > > A field for the name of the field. > A field for the kind of information that will be stored in the field > (TINYINT,DOUBLE,TEXT...) > A field for the size of the field. > A field for the atributes of the field (BINARY, UNSIGNED, UNSIGNED ZERO > FILL) > A field for the null option (NULL, NOT NULL). > A field for an information that I don't know... > A field for the Extra(AUTO_INCREMENT). > A selectable field named primary(check it or not). > A selectable field named index(check it or not). > A selectable field named unique(check it or not). > A selectable field named Fulltext(Check it or not). > > The information that I would need would be what are the configurations > that I have to put in each of these fields. > And also I would need to know a php script to access the fields, and > write to new fields. > > Thanx, Rodrigo > >