Download

"; $c="select kategoria from download group by kategoria order by kategoria"; $result= mysql_query($c); while ($arr=mysql_fetch_row($result)) {$dzialy[]=$arr[0];} mysql_free_result($result); $x=0; for ($j=0;$j";} echo ""; $z=1;$x=1; } $naz=split('_',$arr[4],2); echo ""; } } echo "
$arr[1]
$arr[2]
Przeznaczone dla: $arr[3]		 $naz[1]
"; } function lewa_menu() { global $conn; echo "

"; //Nowocsi $c="select id,nazwa,kategoria,subkategoria,cena from oferta where znaczniki like '%n%' order by kategoria,subkategoria,nazwa"; $result= mysql_query($c); if (mysql_numrows($result)>0) { //echo "
NOWOSCI
"; echo "
"; while ($arr=mysql_fetch_row($result)) { if ($arr[4]!='tel.') {$arr[4].=' zł';} echo " $arr[1] - $arr[4]
"; } echo "

"; } mysql_free_result($result); //Promocje $c="select id,nazwa,kategoria,subkategoria,cena from oferta where znaczniki like '%p%' order by kategoria,subkategoria,nazwa"; $result= mysql_query($c,$conn); if (mysql_numrows($result)>0) { echo "
"; while ($arr=mysql_fetch_row($result)) { if ($arr[4]!='tel.') {$arr[4].=' zł';} echo " $arr[1] - $arr[4]
"; } echo "

"; } //Wyprzedaż $c="select id,nazwa,kategoria,subkategoria,cena from oferta where znaczniki like '%w%' order by kategoria,subkategoria,nazwa"; $result= mysql_query($c,$conn); if (mysql_numrows($result)>0) { echo "
"; while ($arr=mysql_fetch_row($result)) { if ($arr[4]!='tel.') {$arr[4].=' zł';} echo " $arr[1] - $arr[4]
"; } echo "
"; } echo "
"; } function bok() { global $conn, $zakupy, $kategoria, $subkategoria, $szczegoly; echo "
Powrót >>
"; echo " Aktualnosci
"; $c="select kategoria from oferta group by kategoria"; $result= mysql_query($c,$conn); while ($arr=mysql_fetch_row($result)) { $tk[]=$arr[0]; } mysql_free_result($result); for ($i=0;$i$tk[$i]
"; if ($tk[$i]==$kategoria) { $c="select subkategoria from oferta where kategoria='$kategoria' group by subkategoria"; $result1= mysql_query($c,$conn); while ($ar1=mysql_fetch_row($result1)) { $ts[]=$ar1[0]; } for ($j=0;$j$ts[$j]
"; } if ($ts[$j]==$subkategoria) { $c="select id,nazwa from oferta where kategoria='$kategoria' and subkategoria='$subkategoria' order by nazwa"; $result2= mysql_query($c,$conn); while ($ar2=mysql_fetch_row($result2)) { echo "
$ar2[1]
"; } } } } } if ($zakupy) {echo "
Karta zamówienia >>
";} } function linki($link) { global $conn; $c="select * from linki where id=$link"; $r = mysql_query($c) or die ("Invalid query"); $arr=mysql_fetch_row($r); echo " $arr[1]



$arr[3]
>>POWRÓT "; } function tablica($tablica,$tytultablicy) { global $conn,$id ; // uwaga do aktualnosci if (ereg('Aktual',$tytultablicy)>0) {$a=1;$b=4;$c=10;} else {$a=0;$b=1;$c=100;} if ($id) {$a=1;$b=1;$c=0;} //echo "a= $a, b= $b, c =$c"; if ($id) {$id=" and id=$id";} echo " $tytultablicy

"; $cmd="select * from $tablica where grupa='$tytultablicy' $id order by data desc"; //echo "$cmd
"; $r = mysql_query($cmd,$conn) or die ("Invalid query"); $l=0; while ($arr=mysql_fetch_row($r)) { $l++; if ($arr[5]=='0000-00-00') {$arr[5]='';} if ($arr[6]) {$arr[6]="";}; if ($arr[7]) {$arr[7]="
$arr[7]";} if ($l<=$a) { echo "
 $arr[2]$arr[5] 

$arr[3]
$arr[6]$arr[4] $arr[7]


"; } else if ($l<=$b) { echo "
 $arr[2]$arr[5] 

$arr[6]$arr[3]
więcej


"; } else if ($l<=$c) { //if ($arr[4]!='0000-00-00') {$arr[4]="($arr[4])";} else {$arr[4]='';}; echo "$arr[5] $arr[2] więcej...
"; } } echo "
"; if ($id) { echo "Powrót"; } } mysql_close($conn); ?>