I have this table built like this, which assigns a unique articleId starting with zero for each user.
There also is a part which assigns a running serial number (artcStackId) to each article. You'll see in the code.
Thing is, is it somehow possible to assign a artcStackId based on the country of the user? That country code will come from php.
Eg: If it's US then start from 10001+1, if its UK start from 20001+1, if its CA then start from 30001+1 and on & on.
Will it be possible to do this?
My current SQL query goes as follows:
But the way I want it it'll have to go like (this is just an example sql):
Any idea how this can be done? Thanks.