php/sql database?

Question

I am using myphpadmin through yahoo

i typed this q a few times now and no one gets me or they are telling me things that are not an option on my interface

so i will show you this time
i need something like this
http://my.monster.com/Account/Account.aspx

i will b using the varchar for the majority of the fields but what do i need to do for a field like state where a drop down of options comes up?

Answer 1

You'd set a field type of enum and indicate which values you want to allow in the field with commas and single-quotes in the Length/Values box.

For example, if you had a column named States, you could set to be an enum with the values 'Maine','New Hampshire','Virginia','Ohio','Washington'

Answer 2

For things like State and Country and Zip Code there are base tables.These Tables are called master data.
You need to create these tables and every time load the data for the Fields from these tables based on their Dependencies.
Whatever the user seletcs is then a Transaction or Intermediate table and stored in your database table with foreign keys to these tables. Let me know in case you want more information on how to do this.

Answer 3

you should connect to the Database with own homestead web page. get at the same time: ( is going on the accurate of the own homestead web page codes )