custom "favorites" list

I want to be able to make a custom "favorites" list of links that the users creates, and then it displays the list of favorites stored under their username.

I have a unique ID number for each link, and the username is pulled from their NT LOGON_USER.

how do i save this to a DB and then display the records on the "favorites" page?

please let me know if i need to provide more info...Thanks.

Thanks michael for the help.

I want to be able to store MULTIPLE link id's (or "link favorites") for each userID, and then display the favorites on the page when the user visits the "favorites" page.

The table layout that you have gives just one link per user.
Do i need multiple tables in my DB with some kind of relationship between them  or what?

What if i did something like this? I could just loop through and find the "True" values for a certain user's column...

idNum	linkURL	linkName	user1	user2
1	www.microsoft.com	Microsoft	True
2	www.chicken.com	Chickens
Flamewave Members Profile Find Members Posts Senior Member Joined: 19 June 2002 Location: United States Status: Offline Points: 376	Post Options Post Reply Quote Flamewave Report Post    Thanks(0)    Quote  Reply Posted: 06 August 2003 at 8:19am
	Why have a column for every user though when you could just have one column that stores the username, then in your select statement, you can filter out all the records that dont belong to that user by adding something like this: where username = 'user1'. That will return a recordset with all of the links for that user.
	- Flamewave They say the grass is greener on the other side, but if you really think about it, the grass is greener on both sides.

Post Reply	Page  12>

Forum Jump -- Select Forum --  Network Status and Announcements  Web Wiz Hosting Services Pre-Sales Questions  Web Wiz Hosting Support Forums  Web Wiz Hosting Support Ticket System  Web Wiz Forums   - Web Wiz Forums Modifications   - Web Wiz Forums Skins   - Web Wiz Forums Language Files   - Web Wiz Forums Suggestions  Web Wiz Forums Demo  Web Wiz NewsPad  Web Wiz CAPTCHA  Web Wiz Rich Text Editor (RTE)  General Discussion  Web Design Discussion  ASP.NET Discussion  Classic ASP Discussion  PHP Discussion  Database Discussion

Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum