Favorites In DB, Duplicity Checkup

I'm trying to give to my site's visitors an option of edding some records to the list of favorites. Favorites is a table in the DB, called fav_recs, with 3 fields: fav_id (auto number), rec_id, user_id. User can see his favs when entering the personal page (with user name and password), where there's a query that pulling the rec_id where user_id=session("user_id").

Now, when the user clicks a button "Add to favs" it goes to another page with the rec_id in the queryString. There it supposed to check whether this rec_id already presents in the RS where user_id = session("user_id") and if it does - to present a message saying that the user already has this record on his fav's list, and if it doesn't - to insert it into the table. I tried to do the following: Code:

View Replies


ADVERTISEMENT

Checking Nickname Duplicity

Here's what I'm trying to do: I'm making a page where registered users can edit/update their details, including their nickname. On this page there are an SQL query which is pulling out data from the DB about current user based on his ID number and a form with a few fields (an example -
Code:

<input name="nickname" type="text" id="nickname" value="<%=nickname%>">

). From this page the data is being sent to a validation page, where the code should check whether the nickname is already exists in the DB, and whether it does - to give an error message. The problem is that right now even if the user didn't change his nickname - it gives him an error 'cause it "thinks" that it is a new nickname, and when it checks- it sees that this nickname already exists.
So the question is: how to make this checkup if the nickname wasn't changed - to update the rest, and if it was changed - to check if there's duplicity or not, and if there's not - to update the nickname and all the rest?

View Replies View Related

Favorites In IE

I want to make a link that allows users to add my web site to the favorite in IE. Anyone knows how to do that?

View Replies View Related

Read Favorites

is there a way to read out the users favorites with asp?Or do I have to write a little plugin in vb which posts it to the database?

View Replies View Related

Manage Favorites

how can i make buttons on my web site to import/export favorites from ie a good example of this can be found. can someone give me an idea or link to study on this topic.

View Replies View Related

Favorites List With Cookies

I’m working on a match making site where users can view other peoples ads. One feature I would like is for a user to have a favorites list. If a user likes an ad, they would press the “add to favorites” button and the add would get stored in the users favorites list. I would like to do this with cookies to reduce the load on the database. As I am new to web development, I am wondering what is the best way to use cookies for this. Also, since the favorites list can have as many entries as the user wants, should I use an array, or what would be the best way to store the list in a cookie?

View Replies View Related

Favorites (bookmarks) To Database

how can i put my IE favorites into a database(access).i'm trying to manage my favotites using a web page.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved