Thread GROUP BY Timestamp ?: Tag bei Timestamp herausfinden (30 answers)
Opened by Froschpopo at 2004-08-05 08:00

Froschpopo
 2004-08-05 21:48
#32531 #32531
User since
2003-08-15
2653 Artikel
BenutzerIn
[default_avatar]
jetzt kocht mir aber echt der Kopf....
Code: (dl )
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
my $day_now;
my $day_old = "first";
my $dif = 1;
my @dif_array = ();

while (my @arr2 = $sth_prepare->fetchrow_array()) {
$day_now = substr($arr2[0],8,2);
$dif = $day_now - $day_old unless $day_old eq 'first';
push @dif_array, $dif;
for (@dif_array) {
push @array, 0 while (0..$_);
}
push @array, $arr2[1];
$day_old = $day_now;
}

mal gucken ob das funzelt :D

View full thread GROUP BY Timestamp ?: Tag bei Timestamp herausfinden