Forum PHP.pl

[SQL] pobierz, plaintext 
SELECT vote, COUNT( vote )
FROM polls_votes WHERE poll = 'f' AND FROM_UNIXTIME( `time` , '%Y' ) *1 =2008 AND FROM_UNIXTIME( `time` , '%m' ) *1 =4
GROUP BY vote
ORDER BY vote
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$time = $fmw['main']->getTime();
			$year = strftime("%Y", $time);
			$month = strftime("%m", $time);
			if(intval(--$month) == 0)
			{
				$year--;
				$month = 12;
			}
			$result = $fmw['db']->query("SELECT pv.vote, c.surname, COUNT(pv.vote) AS count FROM polls_votes AS pv, cadre AS c WHERE pv.poll = 'f' AND c.id = pv.vote AND FROM_UNIXTIME(pv.`time`, '%Y')*1 = ".$year." AND FROM_UNIXTIME(pv.`time`, '%m')*1 = ".$month." GROUP BY pv.vote ORDER BY count DESC LIMIT 3");
?>
[PHP] pobierz, plaintext