redbrad0 Posted March 17, 2008 Share Posted March 17, 2008 I have a system setup that has certain items that people can purchase things for. Once in awhile I need to collect additional information from the user on the item they are purchasing (this is not a full blown shopping cart). A example of some additional information (which can change per each item) would be - Would you like to get information on the teleconference - Will you be staying at the conference hotel - What is the age range of people purchasing tickets - Where did you hear about us So I am trying to figure out the best way to add this into the database and export it out in a clean fashion. My thought is to add a table with column names (OrderInformation_ID, OrderInformation_OrderID, OrderInformation_FieldName, OrderInformation_FieldValue). And build the information into an array to export the data. Does this seem like the best way? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.