Auto Increment Membership Number

8 years 2 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:


unfortunatly this isnt working - please can you help?

screen shot attached.

Thanks. Ben.
8 years 2 months ago #194499 by in8web
Fixed it!

UPDATE `jos_comprofiler` SET `cb_membership2` = [user_id]+ 25000;
Moderators: beatnantkrileon
Time to create page: 0.415 seconds

Facebook Twitter LinkedIn