Помогите написать запросы в базу

define('_IN_JOHNCMS', 1);
$headmod = 'online';
$textl = 'Онлайн';
require_once('../incfiles/core.php');

$q = mysql_query("SELECT forum.user_id, COUNT(*) as count FROM users LEFT JOIN forum ON users.id=forum.user_id WERE forum.type='m' GROUP BY count DESC LIMIT 9");
 while($row = mysql_fetch_assoc($q)){
 $arr[] = $row['count'];
 }
 file_put_contents('file.txt',$arr);

 $text = file_get_contents('file.txt');
echo $text;

<?php
define('_IN_JOHNCMS', 1);
$headmod = 'graf';
$textl = 'граф';
require_once('../incfiles/core.php');
$q = mysql_query("SELECT forum.user_id, COUNT(*) as count FROM users LEFT JOIN forum ON users.id=forum.user_id WERE forum.type='m' GROUP BY count DESC LIMIT 9");
 while($row = mysql_fetch_assoc($q)){
$arr[] = $row['count'];
 }
file_put_contents('file.txt',$arr);
$text = implode(',',$arr);
echo $text;
?>

Krite (11.05.2011/15:15)
Не правильный запрос. ему считать надо кол-во постов. Надо group by использовать и LEFT JOIN

$query = mysql_query("SELECT `name`, `postforum` FROM `users` ORDER BY `postforum` DESC LIMIT 9");
while($row = mysql_fetch_assoc($query)){
$arr[] = $row['name'] . '  ' . $row['postforum'] . '<br/>';
echo $arr;
}
$file = 'file.php';
if(is_file($file){
$fo = fopen($file, 'w+');
fwrite($fo, $arr);
fclose($fo);
}
echo 'FILE WRITE IS OK!)';