Arkadaşlar aşağıdaki kod ile geçen ayki kayıtların toplamı listeleniyor. Bunu dünkü kayıtlar toplamı olarak nasıl değiştirebiliriz.

<?php

'<table valign="top" width="220" cellspacing="5">
		    ';
		   		list($yil, $ay, $gun) = explode("-", $date);
switch ($ay) {
    case "01":
        $gecenAy = "12";
        $yil = $yil-10;
        break;
    case "02":
        $gecenAy = "01";
        break;
    case "03":
        $gecenAy = "02";
        break;
    case "04":
        $gecenAy = "03";
        break;
    case "05":
        $gecenAy = "04";
        break;
    case "06":
        $gecenAy = "05";
        break;
    case "07":
        $gecenAy = "06";
        break;
    case "08":
        $gecenAy = "07";
        break;
    case "09":
        $gecenAy = "08";
        break;
    case "10":
        $gecenAy = "09";
        break;
    case "11":
        $gecenAy = "10";
        break;
    case "12":
        $gecenAy = "11";
        break;
}
		    $result = @mysql_query("select id, sum(vote) as toplam from poem_gdsr_votes_log where (voted between '$yil-$gecenAy-00' and '$yil-$gecenAy-31') group by id order by toplam desc limit 10");		
		    $i = 1;
		    while(list($poemid, $vote) = @mysql_fetch_row($result)){
		    list($posttitle) = @mysql_fetch_row(@mysql_query("select post_title from poem_posts where ID='$poemid'"));
			if($posttitle){
		    echo "
                  <tr>
                    <td width=100% valign=top style=\"background-color:#ffffff;padding-left: 10px\"><b>$i.</b> <a href=\"http://poemhouse.net/?=$poemid\" title=\"$posttitle Profili\">$posttitle</a> </td>
                    <td width=100% valign=top style=\"background-color:#ffffff;padding-left: 10px\"><div align=\"right\"><strong>$vote</strong></div></td>
                  </tr>
		    ";
		    
		    $i++;
		    }}
		    echo '
	      </table>

' ?>