Programming in mysql: User defined data collection help ColdFusion on newest questions tagged mysql – Stack Overflow
I am trying to figure out what is the best way to accomplish data collection.
Here is what I need to get accomplish:
I am building a CRM using ColdFusion & MySQL to collect data.
The data is different base on each user.
User 1: Collecting :: First Name, Last Name, Phone 1, Phone 2, Address User 2: Collecting :: First Name, Middle Name, Last Name, Phone 1, City, State, Zipcode, Address User 3: Collecting :: Bank Name, User Accounts, Business Name, Address of Bank
To summarize What would be the best way to store it in MySQL and allow easy CRUD (Create, Retrieve, Update, Delete). How can i go about letting the user defined their data. Not to mention speed, pulling thousands of record per query by users interaction. Searching the Data etc…
Any example or answer is appreciated.
Programming in mysql: programming-in-mysql