Auto Increment Membership Number

7 years 5 months ago #194293 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:
7 years 5 months ago #194499 by in8web
Fixed it!

UPDATE `jos_comprofiler` SET `cb_membership2` = [user_id]+ 25000;
Moderators: beatnantkrileon
Time to create page: 0.354 seconds
Facebook Twitter Google LinkedIn