Thread: Count
View Single Post
  #7  
Old 23rd October 2011, 11:34
FTWR FTWR is offline
Senior Member
 
Join Date: Sep 2011
P2P
Posts: 34
Default
Quote:
//Uploaded Torrents
$res3 = mysql_query("SELECT COUNT(*) FROM torrents WHERE owner=" . $user["id"] ."") or print(mysql_error());
$row2 = mysql_fetch_row($res3);
$uploaded_torrents = $row2[0];
//Forum Posts
$res = mysql_query("SELECT COUNT(*) FROM posts WHERE userid=" . $user['id']) or sqlerr();
$arr3 = mysql_fetch_row($res);
$forumposts = $arr3[0];
.....
Reply With Quote