mysql queries and php

[dave1236]

I turn to the boards for assistance once again...

I am trying to implement a feature that allows registered users the ability to review their activity on my site, but am unsure of how to effectively do this and was hoping someone might be able to offer suggstions.

I envision using their login name and password to access this feature, but am unsure how to properly code the queries as well as format the output.

Thanks

[genusapiens]

Hello dave1236, can you please be more specific as to what sort of user activities you want to track? Do you have a database back-end for your site?

[dave1236]

Here is some additional specifics...I have a mysql database on the backend. I have a login page where users can register and create a user name and password.

Basically, as an incentive to get people to return to the site, I offer a rewards program where they get points for purchases. I am trying to create a table and the necessary queries so that a user can check the stauts of their account. I load activity into a table, and want the queries to select * from a table where the login name is the primary key.

My research into this problem confuses me, as I am unsure how to proceed.

Thanks.

[Storyman]

Dave,

To be sure I understand. When someone makes a purchase on your site they earn bonus points. You want the user to know how many bonus points that they have earned. Is this what you are after?