Bald Bouncer
11-26-2001, 09:02 PM
$startcount3=$DB_site->query_first("SELECT COUNT(*) AS posts FROM thread WHERE forumid IN (21,22) AND postuserid='$userinfo[userid]'AND open!='10'");
if the above allows you to count threads made by a user in 2 forums, does anyone know how to change it too count replies made...I tried the below but it wouldnt work :(
$startcount3=$DB_site->query_first("SELECT COUNT(*) AS posts FROM posts WHERE forumid IN (21,22,23,67,25,54,27) AND postuserid='$userinfo[userid]'AND open!='10'");
thanks
if the above allows you to count threads made by a user in 2 forums, does anyone know how to change it too count replies made...I tried the below but it wouldnt work :(
$startcount3=$DB_site->query_first("SELECT COUNT(*) AS posts FROM posts WHERE forumid IN (21,22,23,67,25,54,27) AND postuserid='$userinfo[userid]'AND open!='10'");
thanks