TheMovieman Posted December 21, 2007 Share Posted December 21, 2007 I want to install a script so users can rate the movies I reviewed. The script I found makes sense but I don't know how to do something. The first step is easy: creating a table for the ratings. Each one will get its own id to go along with the associated item (in my case, review). Ok, what I want to do is use my review id as the id for the rating (so all I have to do is have it call the $id variable I've already set up). How can I copy every review id (I have a dvd reviews table) into the ratings id? BTW, in case its important, there are a total of 4 columns in the ratings table: id, total_votes (default 0), total_value (default 0) and used_ips After that, I think it should be easy (hopefully) as all I have to do is place the appropriate code and direct the javascript paths and such... Quote Link to comment Share on other sites More sharing options...
TheMovieman Posted December 22, 2007 Author Share Posted December 22, 2007 Ok, found the right SQL format and got it done. Quote Link to comment Share on other sites More sharing options...
TCH-Bruce Posted December 22, 2007 Share Posted December 22, 2007 Sorry you received no help but glad you sorted it out. 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.