Spot on. In my case I coded the level on the profile but I am also thinking it to add it to the column on users.Quote:
Ragnorak: Assuming you just want to test for entitlement it sounds like you simply want a column on your users table for the total sales and level, then after each sale call those values.
And then
if (*level
less than 2 && sales > 19 )
mysql_query( "update users set level =2" );
Or if the levels are going to be predetermined by sales anyway you can just use the total sales variable to define the level on the sales page
if (*sales >19) *level =2;
if (*sales > 39) *level =3;
etc
I hope I understood what you wanted correctly.