need phpmyadmin enter data help

[rcayea]

Hi everyone,

I have a select-and-go list as part of my order form. Here is the code for it:

Code: Select all

<select name="selectpoemtype">
      <option orderfourline="">4 Line Poem/$15</option>
      <option ordereightline="">8 Line Poem/$25</option>
      <option ordertwelveline="">12 Line Poem/$40</option>
      <option ordersixteenline="">16 Line Poem/$50</option>
      <option ordertwentyline="">20 Line Poem/$75</option>
   </select>


How do I enter these options into my phpmyadmin table? What would I enter into "column" and "type" and so on?

Thank you,
Randy[/img]

[ollie]

They would be TEXT (65,535 characters) or MEDIUMTEXT (16,777,215 characters) field types.

[DarkSnow]

It depends very much on the rest of the application.

Firstly I should point out that this is not valid HTML. Each of the option elements has an invalid attribute. You should perhaps have a value="" with the value in it.

As to what that value should be. Well, it could be a string, as suggested in the first reply, but an easier way might be to use an integer and have the number of lines in the poem. Or even an integer with the primary key in your "poem type" table.

That table could then contain the price, description, line count, etc.

So, as I say, it depends how you've written the rest of the app.