Help with setting up a subscription method

[STyL3]

Okay...so first things first with this being my first post. I'm new to PHP and MySQL with a basic understanding of it. Now what I want to do is come up with a way for a user to subscribe to a given page on my site.

For example, say Dumb.User has his own account 'Subscription List' on mysite.com. If he comes across a page with an interesting article on it, I want him to be able to click on a subscription link and add the page to his 'Accounts Subscription' list.

This way he can later pull up the subscription page and see all of the pages he subscribed to.

I'm not exactly sure what the best way is, to set up the link and what it would call.

Thanks for any help.

[bpat1434]

Well, the easiest would be to have two tables: One for the users and one for the subscriptions. The users table would hold the general information about the user (unique ID, email address, name, username, password-hash, etc.) and the subscriptions table would hold all the subscriptions links along with the user-id that it's linked to. So some sample tables:

-- Table: Users
id | username |             password             | name  |      email      |
 1 | bpat1434 | c132m1n1n1n6n191n0anz08anz81n491 | Brett | [e-mail] |
 2 | STyL3    | 1na8nznb8018tnt810z9an10q0r9tgw0 | Style | [e-mail] |


-- Table: Subscriptions
id | userID | link
 1 | 2      | http://www.phpbuilder.com/board
 2 | 2      | http://www.php.net
 3 | 2      | http://www.mysql.com
 4 | 1      | http://www.simplemachines.org
 5 | 1      | http://www.phpbb.com
 6 | 2      | http://www.somesite.org

Then when you query the tables, you can get subscriptions by limiting the userID. You can also easily add, modify, and remove subscriptions per-user. Much easier to handle the data returned.

Hope that gets you started in the right direction.

[STyL3]

Awesome. Thanks for your help.