Bi Sql Query İcin Fikir Lazim
-
yardimlariniz icin cok sagolun soyle haletim belki birine lazim olur
<?
$value_union = "";
for($i=1;$i<=31;$i++)
{
foreach(fetch_table("SELECT i_d.value as value
FROM installation i
INNER JOIN installation_details i_d ON i.id = i_d.installation_id
WHERE i_d.key = 'position' AND MONTH(i.timestamp) = Month(NOW()) AND DAY(i.timestamp)=$i") as $I){
$value_union .= $I['value'];
}
$value_union = str_replace("0","",$value_union);
$value_union = str_replace("1","",$value_union);
$value_union = str_replace(",","",$value_union);
$total = strlen($value_union);
$value_union = "";
if($total>0)
echo "d1.push([$i,$total]);";
}
?>
Toplam Hit: 1904 Toplam Mesaj: 12
