Attachments per forum

[Boofo]

Ok, maybe I didn't call it right, then. Here is what I have now.

PHP Code:

$attachs=$DB_site->query_first("SELECT COUNT(p.postid) as count, SUM(LENGTH(a.filedata)) as bytes, f.title
FROM post p, thread t, forum f, attachment a
WHERE a.attachmentid = p.attachmentid AND t.threadid = p.threadid
    AND f.forumid = t.forumid AND p.attachmentid > 0
GROUP BY f.forumid"); 


and I am calling them like this:

$attachs['count'] = number_format($attachs['count']);
$attachs['bytes'] = number_format($attachs['bytes']);

Am I calling them wrong? And my host is using 3.54.xx version of MySQL if that makes any difference.

[filburt1]

It returns multiple rows, not one row (query() instead of query_first()).

[Boofo]

I get these errors at the top of the page when I run the following code:

Warning: Cannot use a scalar value as an array in /home/bear/public_html/forum/forumdisplay.php on line 738

Warning: Cannot use a scalar value as an array in /home/bear/public_html/forum/forumdisplay.php on line 739

PHP Code:

$attachs=$DB_site->query("SELECT COUNT(p.postid) as count, SUM(LENGTH(a.filedata)) as bytes, f.title
FROM post p, thread t, forum f, attachment a
WHERE a.attachmentid = p.attachmentid AND t.threadid = p.threadid
    AND f.forumid = t.forumid AND p.attachmentid > 0
GROUP BY f.forumid"); 


[filburt1]

Iterate through it using $DB_site->fetch_array()...have you extensively worked with MySQL through vB before?

[Boofo]

Not a whole lot, no. Simple queries, I can usually do.

I must not be getting it right or understanding it, I guess. I am still getting errors. This time it is:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/bear/public_html/forum/admin/db_mysql.php on line 149

[filburt1]

Iterate as such (just an example):

PHP Code:

$result = $DB_site->query(...);
while ($bits = $DB_site->fetch_array($result))
{
    // do stuff with $bits which is one row from the result
} 


[Boofo]

We figured out what I was doing wrong with the original code in post #1. I forgot to add:

AND forum.forumid=$forumid

to the end of it. Now it returns the right info for each forum and runs fast.