Count

[FTWR]

I need a function to cleanup.php file to count how much uploaded torrents and forum posts have every user.

$uploaded_torrents = mysql_query("SELECT COUNT(*) FROM torrents WHERE owner=" . $user["id"] ."") or print(mysql_error());

$forum_posts = mysql_query("SELECT COUNT(*) FROM posts WHERE userid=" . $user['id']) or sqlerr();

Where is the mistake because the lines don't work.

P.S: I use Tbdev 2009!

[joeroberts]

try it like so

PHP Code:

$uploaded_torrents = mysql_query("SELECT COUNT(id) FROM torrents WHERE owner=" . $user["id"] ."") or print(mysql_error()); 


PHP Code:

$forum_posts = mysql_query("SELECT COUNT(id) FROM posts WHERE userid=" . $user['id']) or sqlerr(); 


mysql don't like to count wild cards

[FTWR]

Don't work!

Notice: Undefined variable: user in /home/admin/***/include/cleanup.php on line 153
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Notice: Undefined variable: user in /home/admin/***/include/cleanup.php on line 154
MySQL Error

There appears to be an error with the database.
You can try to refresh the page by clicking here.

Error Returned

[joeroberts]

the query works you just gave me the wrong variable you need to fix $user['id']

Notice: Undefined variable: user in /home/admin/***/include/cleanup.php on line 153

[FTWR]

The code is from userdetails.php. Do you think it work with that:

$id = 0 + $_GET["id"];

[joeroberts]

I would need to see the complete code to see what is going on and what your trying to do.

[FTWR]

//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];

.....

[joeroberts]

are you trying to update for every user?
where is the $user["id"] part suppose to be coming from?
what are you doing with the information after you get it?

[FTWR]

Yes, for every user. With the information I will use it to promote at a new class (at a number of torrents).