Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Hi
I am trying to apply membernumber to our users/members. So when they subscribe they get a member number. The code I used is below. what I would really like is a way to automate the process. Use the SQL feature to save the last membernumber and then use it to assign a new member with a new number by adding one and then saving it again in a last membernumber table. this process works when i run SQL in phpMyAdmin but not with CBsubs. Can someone help?
Code:
UPDATE '#_comprofiler'
SET
'cb_membernumber'=1
WHERE 'user_id'=[user_id]
As you can see at this time I am only trying to add a number to a singe user who subscribed.
Code:
UPDATE '#_comprofiler'
SET
'cb_membernumber'=jos_membernumber.lastnumber+1,
jos_membernumber.lastnumber=jos_membernumber.lastnumber+1
WHERE 'user_id'=[user_id]
As you can see here it would be automated where a new number would be stored as the last number used and the next time that number can be used to create a new number.
Please help.
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.