help pleaserelating "php admn"

[pma-import]

please help to:

after i logged in to my php account i.e. "php admn". to create table...what name and fields do i enter to get success ? I have been getting SQL ERRORS. *****in the page "php admn. to create table...what name and fields do i enter to get success? "

---

• Original URL: "https://sourceforge.net/p/phpmyadmin/support-requests/657/":https://sourceforge.net/p/phpmyadmin/support-requests/657/
• Original author: tgopala_krishna

[pma-import]

Logged In: YES user_id=210714

Please show us the exact SQL error message you get.

---

• Original author: lem9

[pma-import]

• assigned_to: nobody --> lem9

---

• Original author: lem9

[pma-import]

Logged In: YES user_id=1251066

Atlost created thus:http://www.synow.org/phpmysql/2.htm

The Contacts Database

The contacts database will contain all the conact information for the people you enter and the information will be able to be edited and viewed on the internet. The following fields will be used in the database:

Name Type Length Description

id INT 6 A unique identifier for each record

first VARCHAR 15 The person's first name

last VARCHAR 15 The person's last name

phone VARCHAR 20 The person's phone number

mobile VARCHAR 20 The person's mobile number

fax VARCHAR 20 The person's fax number

email VARCHAR 30 The person's e-mail address

web VARCHAR 30 The person's web address

You may be wondering why I have used VARCHAR fields for the phone/fax numbers even though they are made up of digits. You could use INT fields but I prefer to use VARCHAR as it will allow dashes and spaces in the number, as well as textual numbers (like 1800-COMPANY) and as we will not be initiating phone calls from the web it is not a problem.

There is one other thing you should be aware of in this database. The id field will also be set as PRIMARY, INDEX, UNIQUE and will be set to auto_increment (found under Extra in PHPMyAdmin). The reason for this is that this will be the field identifier (primary and index) and so must be unique. The auto increment setting means that whenever you add a record, as long as you don't specify an id, it will be given the next number.

If you are using PHPMyAdmin or a management program you can now create this in a table called contacts.

---

• Original author: tgopala_krishna

[pma-import]

Logged In: YES user_id=1251066

Atlost created thus:http://www.synow.org/phpmysql/2.htm

The Contacts Database

The contacts database will contain all the conact information for the people you enter and the information will be able to be edited and viewed on the internet. The following fields will be used in the database:

Name Type Length Description

id INT 6 A unique identifier for each record

first VARCHAR 15 The person's first name

last VARCHAR 15 The person's last name

phone VARCHAR 20 The person's phone number

mobile VARCHAR 20 The person's mobile number

fax VARCHAR 20 The person's fax number

email VARCHAR 30 The person's e-mail address

web VARCHAR 30 The person's web address

You may be wondering why I have used VARCHAR fields for the phone/fax numbers even though they are made up of digits. You could use INT fields but I prefer to use VARCHAR as it will allow dashes and spaces in the number, as well as textual numbers (like 1800-COMPANY) and as we will not be initiating phone calls from the web it is not a problem.

There is one other thing you should be aware of in this database. The id field will also be set as PRIMARY, INDEX, UNIQUE and will be set to auto_increment (found under Extra in PHPMyAdmin). The reason for this is that this will be the field identifier (primary and index) and so must be unique. The auto increment setting means that whenever you add a record, as long as you don't specify an id, it will be given the next number.

If you are using PHPMyAdmin or a management program you can now create this in a table called contacts.

---

• Original author: tgopala_krishna

[pma-import]

Logged In: YES user_id=210714

Please show us the exact SQL error message you get.

---

• Original author: lem9

[pma-import]

Logged In: YES user_id=210714

No reply from user -> closed.

---

• Original author: lem9

[pma-import]

• status: open --> closed

---

• Original author: lem9