Solved: Adding more SQL fields into user info.. EDIT: See answer from David below about SQL field for answer! Need to add more fields into for more info into the member info. Each field needs to have its own MySQL field id by it's self and not bunch grouping like the add fields feature does. Add Fields in amember lumps it all into a field call DATA in the MySQL which is just not even workable or usable in any means by an outside script. I found some old instructions but amember has been updated and changed since then and it doesn't seem quite the same at all. I've sent in a help ticket but hopefully someone here can help or has done this already. Up against a time crunch for delivery and import of members info for client. Anyone here able to help???? They have to be individual fields as this info will be called to another script outside of amember also. So each field has to have its own id in the MySQL Table. I've added the extra rows to the table but don't know where to begin to add it to the amember to enable writing to the database. I'm guessing that only changes to the profile.php and profile.html would be needed. But that is just an assumtion. Thanks, Jeremy
From Admin CP -> Add Fileds (bottom left side under the "Utilities" heading. Do you have any specific questions about how to use that function?
No, That adds everything into a single field in the MySQL database for the user called DATA! Where it lumps all the fields you added via the add fields into one lump of crap which is impossible to pull data from and into another software. amember uses it's processor to unsort the data. The extra fields NEED to have THERE OWN ID in the MySQL database. Add Fields in amember DOES NOT DO THIS!!!! It has to be manually added to he scripts in amember and manually added to the MySQL database to call the id of the field. I guess amember doesn't work weekends or Fridays. I sent my request in on Thursday evening and second on Friday morning. Takes so long for them to get back with you on everything.
OMG, I need a vacation. How the heck did I miss that!! I have to many projects going on and not enough time to go over using amember. I will stand in the corner with my dunce hat now..... Thank you for bringing reality back to the table. Okay, how can I change the order of the added fields to be placed where I want in the admin edit user info, the sign-up form and users edit info? Which templates control the order, or what do I add to which page to make it show in the spot I want? Profile /.html and .php ??? Also, David do you do custom work for other things in amember? For future reference I would like to get a good list of people here who can do other projects in the future. Thanks, Jeremy