folder Tahribat.com Forumları
linefolder Database - Veritabanı
linefolder Bi Sql Query İcin Fikir Lazim



Bi Sql Query İcin Fikir Lazim

  1. KısayolKısayol reportŞikayet pmÖzel Mesaj
    geniuss
    geniuss's avatar
    Kayıt Tarihi: 12/Nisan/2007
    Erkek

    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