![]() | ||
|
$sql = "SELECT id, title, link, dzien, miesiac, rok, godzina, minuta, description, zrodlo FROM english_wiadomosci WHERE (zrodlo=415) ORDER BY rok DESC, miesiac DESC, dzien DESC, godzina DESC, minuta DESC, id DESC LIMIT 0,25";
$wynik = mysql_query($sql);
$start=0;
while ($row = mysql_fetch_row($wynik))
{
if ((strlen($row[3]))<2) $row[3]="0$row[3]";
if ((strlen($row[4]))<2) $row[4]="0$row[4]";
if ((strlen($row[6]))<2) $row[6]="0$row[6]";
if ((strlen($row[7]))<2) $row[7]="0$row[7]";
if ($start==0)
{
print("$row[1] Added : $row[3].$row[4].$row[5], $row[6]:$row[7] $row[8] "); print(" More at : "); print("$row[2]"); print(" "); ?> | ||
|
print(" "); print("Previous news :
News archive : "); $start_y = 2005; while ($start_y<= $obecny_y) { print("Year $start_y - months : "); $start_m = 1; if ($start_y < $obecny_y) $obecny_m = 12; else { $obecny_m = date("m",mktime()); } while ($start_m <= $obecny_m) { $sql = "SELECT count(id) FROM english_wiadomosci WHERE (rok='$start_y' AND miesiac='$start_m' AND (zrodlo=415))"; $wynik = mysql_query($sql); $row = mysql_fetch_row($wynik); if ($row[0]>0) print (" [$start_m] "); $start_m++; } $start_y++; } ?> | ||
|
|