Hello Php Forums!
I have a script that has point system. and if you have enough points you can get rewards example
usb,tshirts etc..
i already done the function when the user redeem his/her points will be deducted based on how much points is needed to redeem that item.
now i have a problem,
i want to display the redeem items name on his/her profile page.
how can i do it?
EXAMPLE STRUCTURE OF THE TABLES:
rewards
rewardid | rewardname | price
1 | USB | 10
USERS
userid | username | points | password |redeemed
1 | code | 500 | 441$!sf | ?????
THANKS!