Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

What's the best way to enter new fields for the following data?

Quote Reply
What's the best way to enter new fields for the following data?
Hi,
I have a a Links SQl database. For one of the records, the user has the option to enter up to 55 playing cards, each card is entered into a seperate field. There is also seperate fields (columns) for a price field for them to enter a price tag.

I now need to enter one more field, which will be a checkbox, one checkbox for each card that they enter, and it will only have one option.

So let me see if I can show how this looks:

Qty Card Name Price Foil

Qty is a column in the database (one column per card such as card1qty, card2qty, card3qty etc up to card55qty)
Card Name is a column in the database (one column per card such as cardname1, cardname2, cardname3 etc up to cardname55)
Price is a column in the database (one column per cards such as card1price, card2price, card3price etc up to card55price)

Now I need to add a new column for the option of the Foil option, and it will be a checkbox with only one option (either yes or no).

Do I need to do as I've been doing, and add those extra 55 fields, one for each item that they enter or is there a better and more expedient way of entering such mass amount of columns in maybe just one column somehow?

I was thinking that maybe it could be simply one column to hold all 55 checkbox options, since checkboxes are usually meant for multiple selections for one record, maybe someone could tell me what the best method is to do this and give me an example of how the html might look for it as well as anything I must enter into the new links column properties.

It's not mandatory for the user to enter the checkmark, if they do enter it, then it's assumed to be yes.

Thanks, I hope I made this clear, it's not easy for me to do so.
Subject Author Views Date
Thread What's the best way to enter new fields for the following data? Westin 7595 May 1, 2009, 6:50 PM
Thread Re: [Westin] What's the best way to enter new fields for the following data?
Andy 7418 May 2, 2009, 1:16 AM
Thread Re: [Andy] What's the best way to enter new fields for the following data?
Westin 7408 May 2, 2009, 1:23 AM
Thread Re: [Westin] What's the best way to enter new fields for the following data?
Andy 7424 May 2, 2009, 1:25 AM
Thread Re: [Andy] What's the best way to enter new fields for the following data?
Westin 7365 May 2, 2009, 1:30 AM
Thread Re: [Westin] What's the best way to enter new fields for the following data?
Andy 7423 May 2, 2009, 1:52 AM
Thread Re: [Andy] What's the best way to enter new fields for the following data?
Westin 7407 May 2, 2009, 2:06 AM
Thread Re: [Westin] What's the best way to enter new fields for the following data?
Andy 7407 May 2, 2009, 2:09 AM
Thread Re: [Andy] What's the best way to enter new fields for the following data?
Westin 7365 May 3, 2009, 8:47 AM
Thread Re: [Westin] What's the best way to enter new fields for the following data?
Westin 7382 May 3, 2009, 7:06 PM
Post Re: [Westin] What's the best way to enter new fields for the following data?
Andy 7382 May 4, 2009, 1:30 AM