Делаю себе на сайт мод мне нравиться для коментариев вот код
[code]$q = mysql_query("SELECT * FROM
`avkom` WHERE `id` = '{$id}'"
$avkomm = mysql_fetch_assoc($q);
if (isset($user)) {
if (isset($_GET['Like'])) {
$q = mysql_query("SELECT * FROM
`avkom_like` WHERE `id_avkom` =
'{$avkomm['id']}' AND `id_user` =
'{$user['id']}'"
if (!mysql_num_rows($q)) {
mysql_query("INSERT INTO
`avkom_like` (`id_avkom`, `id_user`,
`time`) VALUES ('{$avkomm['id']}',
'{$user['id']}', '" . ($time + 1) . "')"
mysql_query("UPDATE `avkom` SET
`like_count` = `like_count` + '1'
WHERE `id` = '{$avkomm['id']}'"
if ($ank['id'] != $user
['id'])mysql_query("INSERT INTO
`mail` (`id_user`, `id_kont`, `msg`,
`time`) values('0', '{$ank['id']}',
'{$user['nick']} оценил Ваш коментарий [url=/users/avkom.php?id={$avkomm['id']}]{$avkomm
['name']}[/url]', '{$time}')"
} else {
mysql_query("DELETE FROM
`avkom_like` WHERE `id_avkom` =
'{$avkomm['id']}' AND `id_user` =
'{$user['id']}' LIMIT 1"
mysql_query("UPDATE `avkom` SET
`like_count` = `like_count` - '1'
WHERE `id` = '{$avkomm['id']}'"
if ($ank['id'] != $user
['id'])mysql_query("INSERT INTO
`mail` (`id_user`, `id_kont`, `msg`,
`time`) values('0', '{$ank['id']}',
'{$user['nick']} недооценил Ваш
коментарий [url=/users/avkom
.php?id={$avkomm['id']}]{$avkomm
['name']}[/url]', '{$time}')"
}
header('Location: ?id=' . $avkomm
['id']);
exit;
}
}[/code]
вот вывод
[code]if (isset($user)) {
echo "<a href='?id={$avkomm
['id']}&Like'><img src='/style/
img/like.png'><span
style='color:#799dc1; font-
size:12px;'><b>{$avkomm
['like_count']}</b></span> ".
(mysql_resylt(mysql_query("SELECT
COUNT(*) FROM `avkom_like`
WHERE `id_avkom` = '{$avkomm
['id']}' AND `id_user` = '{$user
['id']}'", 0) != 0 ? '<span
style="color:silver;">Мне
нравтся</span>' : '<span
style="color:#799dc1;">Мне
нравится</span>' ) ."</a>";
} else echo "<img ' src='/style/img/
like.png' alt='' /> <span
style='color:#799dc1;'>Мне
нравтся</span>";[/code]