Просмотр поста

selemet, пробуй через пма
$sql = "select (SELECT COUNT(*)
FROM `cms_mail` LEFT JOIN `cms_contact`
ON `cms_mail`.`user_id`=`cms_contact`.`from_id`
AND `cms_contact`.`user_id`='$user_id'
WHERE `cms_mail`.`from_id`='$user_id'
AND `cms_mail`.`sys`='0' AND `cms_mail`.`delete`!='$user_id'
AND `cms_contact`.`ban`!='1' AND `spam`='0') as `m1` , (SELECT COUNT(*)
FROM `cms_mail` LEFT JOIN `cms_contact`
ON `cms_mail`.`user_id`=`cms_contact`.`from_id`
AND `cms_contact`.`user_id`='$user_id'
WHERE `cms_mail`.`from_id`='$user_id'
AND `cms_mail`.`sys`='0' AND `cms_mail`.`delete`!='$user_id'
AND `cms_contact`.`ban`!='1' AND `spam`='0') as `m2` , ( SELECT COUNT(*) FROM `cms_mail` LEFT JOIN `cms_contact` ON `cms_mail`.`user_id`=`cms_contact`.`from_id` AND `cms_contact`.`user_id`='$user_id' WHERE `cms_mail`.`from_id`='$user_id' AND `cms_mail`.`sys`='0' AND `cms_mail`.`read`='0' AND `cms_mail`.`delete`!='$user_id' AND `cms_contact`.`ban`!='1' AND `cms_mail`.`spam`='0') as `m3`, `users`.`id` from `users` where `id` = '" . $user_id . "'";
$res = mysql_fetch_assoc(mysql_query($sql));
echo '<pre>';
print_r($res);
пробуй