123SELECT count(*) FROM who_voted WHERE vid=41200 AND ip=INET_ATON('38.107.179.220')INSERT INTO video_ratings (vid,rating,rate_five) VALUES (41200,57.1111111111,1)
ON DUPLICATE KEY UPDATE rate_five=rate_five+1
UPDATE video_ratings SET votes_total=votes_total+1, rating=57.1111111111 WHERE vid=41200
INSERT INTO who_voted (vid,ip,date) VALUES (41200,INET_ATON('38.107.179.220'),NOW())
|
||||||||||||||||||||||
|
||||||||||||||||||||||
|
||||||||||||||||||||||
|
Submit website
|
||||||||||||||||||||||