auto updating IM_users table with my users table

[montyy]

hi there, this is my first post, I like this software, its great..

my Question is:

I have a sign up form, and when the sign up button is clicked it puts the data into my users table, is it possible when entering the data  in my users table  to automatily put that information (ie: firstname, lastname ,email) in to my lm_users table.

i dont want to manully do it, if you no what i mean..
I am building a site for a client, so i need that part to be auto..

you see the users on my site can only view there own info, and all so they can update and edit there own information.

At the moment when the user changes eg: there email address,  it only updates my users table and not the lm_users table.

so in summary ,at the moment i have 1 table with a user email address and another table with the same user email address. This is because i have manully imported the data from my users table to the lm_users table..

I a a couple of ideas , but would like to get your opinion first..
Cheers..thank you..

[DW]

Greetings, welcome to ListMail and the forum!

It is possible to automatically insert users into ListMail with custom script, such as seen in this post.

Updating your lm_users (it's actually LM_users, not capitalized) table could be as easy as this:

In your custom users script when the user changes their email address, track the old address and the new address.  Using both, query the ListMail lm_users table:

update lm_users set email = 'newemail@site.com' where email like 'oldemail@site.com'

Better would be to track the ListMail id or uid in your users table (or track the users table row id in the ListMail table stored in a custom field) and update them based on that, but the above solution would be a quick and easy hack.

Does this make any sense?

Regards

[montyy]

hi there
 thank you for your input, what i did was i created a 2nd form in my sign up pages, and the user recomferms there login details which in turn puts that information into my list, so it seems to work ok..

thank you for your support.

Troy