SELECT *
FROM (SELECT `page_id`, max(`datetime`) AS `datetime`
FROM `f_comments`
WHERE `user` = {$userId}
GROUP BY `page_id`) AS `my`
LEFT JOIN `f_comments` AS `other` ON `other`.`page_id` = `my`.`page_id`
WHERE `other`.`user` != {$userId}
AND `other`.`datetime` > `my`.`datetime`<?php
$rowblock = -2;
$rows = array();
foreach ($profile as $i => $user) {
if ($i%4 == 0) {
$rows[] = '<tr>';
$rows[] = '<tr>';
$rowblock += 2;
}
$rows[$rowblock] .= "<td><img src='/profile/user/{$user['pro_img']}'>";
$rows[$rowblock+1] .= "<td><p>{$user['pro_fam']} {$user['pro_im']} {$user['pro_otch']}<p>{$user['dol_name']}";
}
for ($i = $i%4; $i < 3; $i++) {
$rows[$rowblock] .= "<td>";
$rows[$rowblock+1] .= "<td>";
}
echo "<table>",implode('', $rows),"</table>";
?>$sql = $construct->query("{$query}")->$fetchType;$sql = $construct->query($query)->$fetchType;
UPDATE `table` SET `updated` = 0 WHERE `user_id` = $uidINSERT INTO `table` (`user_id`, `obj_id`, `updated`) VALUES ($uid, $oid, 1)
ON DUPLICATE KEY UPDATE `updated` = 1DELETE FROM `table` WHERE `user_id` = $uid AND `updated` = 0$totalAward = 100;
$maxEarn = -1;
$numWinners = 0;
foreach($gamers as $gamer) {
if ($gamer['earn'] == $maxEarn)
$numWinners++;
elseif ($gamer['earn'] > $maxEarn) {
$maxEarn = $gamer['earn'];
$numWinners = 1;
}
}
$result = array();
foreach($gamers as $gamer) {
if ($gamer['earn'] == $maxEarn) {
$gamer['winner'] = -1;
$gamer['award'] = $totalAward/$numWinners;
} else {
$gamer['winner'] = 0;
$gamer['award'] = 0;
}
$result[] = $gamer;
}SELECT @left_key := `left_key`, @right_key := `right_key`
FROM `tree`
WHERE `id` = $id;
SELECT *
FROM `tree`
WHERE `left_key` <= @left_key AND `right_key` >= @right_key
ORDER BY `left_key`;