Arman

$params = array('pin' => '****************'); // или array('****************'); 
  $request = $client->GetPinInfo($params);
  $itog = $request->GetPinInfoResponse;

SELECT
    (SELECT COUNT(a.`id`) FROM `marks` AS a WHERE a.`value` IN ("Отлично")) AS `count_5`,
    (SELECT COUNT(b.`id`) FROM `marks` AS b WHERE b.`value` IN ("Хорошо", "Отлично")) AS `count_4_5`,
    (SELECT COUNT(c.`id`) FROM `marks` AS c WHERE c.`value` IN ("Удов.", "Хорошо", "Отлично")) AS `count_3_4_5`

SELECT
    a.*,
    b.*,
    c.*
FROM
    `contacts` AS a

LEFT JOIN
    `users_app` AS b
ON
    b.id = a.id_contact

LEFT JOIN
    `messages` AS c
ON
    c.`id` = 
        (
        SELECT 
            MAX(d.id) 
        FROM 
            `messages` AS d 
        WHERE 
            (
            d.id_user = a.id_user
            AND
            d.id_from_user = a.id_contact
            )
            OR
            (
            d.id_user = a.id_contact
            AND
            d.id_from_user = a.id_user 
            )
        )
WHERE
    a.id_user = $id_user

# если картинка, то мод реврайт кидает на скрипт,
# обрабатывающий изображения
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ximage/[a-zA-Z\_\-0-9\/]+[.]{1}[jpg|jpeg?] ximg.php

INSERT INTO house VALUES(NULL, 'dsfsd');

SET @house_id = LAST_INSERT_ID();

INSERT INTO kitchen VALUES(NULL, 'sdfsd', @house_id);

INSERT INTO room VALUES(NULL, 'wresdfsdsfdsd', @house_id);

$textareaValue = 'aaa@aaa|aaa/nbbb@bbb|bbb/nggg@ggg|ggg';

$explode_1 = explode('/n', $textareaValue);

foreach ($explode_1 as $value_1)
    {
    $explode_2 = explode('|', $value_1, 2);

    echo $explode_2[0] .': '. $explode_2[1] .'<br />';
    }