Auto Increment Membership Number

12 years 2 weeks ago #194293 by in8web
Auto Increment Membership Number was created by in8web
Hi, i've been looking through the forum about this and although there are a few suggestions to fix i've not found a complete answer:

I'd like to auto create a membership number starting at 25000 and increasing by 1 each time so i was using a sql query in auto action as follows:

UPDATE'[cb_membership]'='[user_id]'+'25000'

unfortunatly this isnt working - please can you help?

screen shot attached.

Thanks. Ben.
Attachments:

Please Log in to join the conversation.

12 years 1 week ago #194499 by in8web
Fixed it!

UPDATE `jos_comprofiler` SET `cb_membership2` = [user_id]+ 25000;

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.291 seconds

Facebook Twitter LinkedIn