PHP script: query Reviewpost database, count # reviews, store result in 'user' table

[criscokid]

What I'm trying to do is create a PHP script (that I'll run at regular intervals via vB cron) that will query a Reviewpost database and count how many reviews a user has made and then post the result for each user in a field in the user database.

I'm new to PHP so your help would be most appreciated. What I've managed to come up with so far is the mySQL query:

SELECT
COUNT(rp_reviews.userid) AS FIELD_1,
rp_reviews.userid
FROM
rp_reviews
GROUP BY
rp_reviews.userid


Othe bits of info...
Reviewpost databse name: reviews
Forum database name: forums
Forum database field: reviewsposted

[BartS]

This should work.


UPDATE userstable AS u
SET u.reviewsposted = (SELECT COUNT(*) FROM rp_reviews AS r WHERE r.userid = u.userid GROUP BY r.userid)