>>>ВОПРОСЫ НОВИЧКОВ<<<

venom, можно одним запросом все вытянут, две строчки кода

Koenig, Как бы я не заморачивался этим , не было потребности...

# Koenig (20.03.2014 / 12:59)
по сути запрос не сложный
дай структуру таблицы писем

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);
пробуй

Koenig, Array
(
[m1] => 0
[m2] => 0
[m3] => 0
[id] => 1
)

а так
$sql = "select `id`, (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` from `users` where `id` = '" . $user_id . "'";
$res = mysql_fetch_assoc(mysql_query($sql));
echo '<pre>';
print_r($res);

Koenig, Array
(
[id] => 1
[m1] => 0
[m2] => 0
[m3] => 0
)

selemet, дома сам попробую , а то с тела не удобно все это копировать

selemet, а письма есть? пару писем напиши или отправь[c][/c]

# Koenig (20.03.2014 / 15:25)
selemet, а письма есть? пару писем напиши или отправь