<--- --------------------------------------------------------------------------------------- ----
Blog Entry:
Ask Ben: Building A jQuery And ColdFusion Rating System
Author:
Ben Nadel / Kinky Solutions
Link:
http://www.bennadel.com/index.cfm?dax=blog:1629.view
Date Posted:
Jul 6, 2009 at 3:10 PM
---- --------------------------------------------------------------------------------------- --->
SELECT
r.id
FROM
rating r
WHERE
r.image_id =
AND
r.ip_address =
AND
r.user_agent =
INSERT INTO rating
(
ip_address,
user_agent,
rating,
date_created,
image_id
) VALUES (
,
,
,
,
);
SELECT
(
SUM( r.rating ) /
COUNT( r.rating )
) AS overall_rating
FROM
rating r
WHERE
r.image_id =
;