Linux Format forums

rcayea · Joined: Sun Apr 19, 2009 1:51 am Posts: 60

Hi everyone,

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

ollie · Posted: Wed Aug 17, 2011 4:05 am Post subject:

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

DarkSnow · Posted: Sun Oct 02, 2011 10:14 pm Post subject:

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.