TeenGamersWorld Posted December 28, 2007 Share Posted December 28, 2007 Let me give some background first.... I am the webmaster of a new video game review website that some of my friends and I decided to start. Only problem is, I have been the only one working on it because I'm the only one who knows what I'm doing. I have been working on this site for three years. Granted it has been sporatic because I am a student (High School) but this site is finally just about done. Now to the problem: I am working on the hints and tips part of my site. I included a link on each hint that allows a visitor that is registered to either report a hint/tip as good or bad. When someone clicks on one of those links, how do I change the value inside the row of that hint so it will increase the value by one? Thanks for any help I get. Quote Link to comment Share on other sites More sharing options...
fenway Posted December 28, 2007 Share Posted December 28, 2007 What do you have so far? Quote Link to comment Share on other sites More sharing options...
TeenGamersWorld Posted December 28, 2007 Author Share Posted December 28, 2007 Currently I don't have much of anything. The link goes to another PHP page that runs the code to change the value. I guess the first thing I would have to figure out is what type of function I am going to use. I thought it would be ALTER at first but that added a row. Any other suggestions. Quote Link to comment Share on other sites More sharing options...
revraz Posted December 28, 2007 Share Posted December 28, 2007 If the record exists, and there is a field that is along the lines of "report" and there is a number in there, you can UPDATE that record, and increment "report" by 1. Quote Link to comment Share on other sites More sharing options...
TeenGamersWorld Posted December 28, 2007 Author Share Posted December 28, 2007 Using the "UPDATE" syntax works perfectly. Thanks. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.