SELECT query from table without relationship

hello -

I need help figuring out an idea I want to do in my PHP web app. The picture attached explains my idea. Can you guys help me out?

the idea is to check if total points in the user table match any reward’s points on the rewards table. If they do, the add the reward name to user (Reward column).

Thanks in advance!!

Are you trying to do this on a user by user basis? Or is this one time update that you are trying to do to update the whole ‘users table’ REWARD column?

Sponsor our Newsletter | Privacy Policy | Terms of Service