[eluser]alexandervj[/eluser]
Hi,
So I have a database thats automatically made from WordPress contact form submissions and I want to use CodeIgniter to build an app to display them, etc. The problem I'm having is the database thats created by the form submissions is in a strange format - it has a few fields (field_name, field_value, time_stamp) but the name, email, and other form fields all get saved to the field_value field. The field_name field just changes based on what they are so if its the submitter's name then the value for field_name is your-name, if its the submitter's email then the value for field_name is their email, etc.
I'm not sure how to build a model, controller, and view for this kind of data. I always have set up my databases and tables so that the field contains one kind of item (i.e. first_name, last_name, email, username, etc.).
Do you have any idea what I can do to display a spreadsheet of the submitter's names, emails, etc.?
Thanks