function Policko($i, $result)
{
$datum1=mysql_Result($result, $i, 'datzavod');
$datum2=mysql_Result($result, $i, 'datkon');
$datkonani= IntVal(Substr($datum1,8,2)).".".IntVal(Substr($datum1,5,2)).".".Substr($datum1,0,4);if ($datum2>0) $datkonani=$datkonani."-".IntVal(Substr($datum2,8,2)).".".IntVal(Substr($datum2,5,2)).".".Substr($datum2,0,4);
$sirka=mysql_Result($result, $i, 'logowidth')==0?"":"width=".mysql_Result($result, $i, 'logowidth');
echo "
";
echo "
";
echo "".mysql_Result($result, $i, 'nadpis')."
";
echo $datkonani."
";
}
?>
Czech o-web katalog - závody
@$spojeni=MySQL_Connect("localhost","milan","bubenec");
if (!$spojeni):
echo "Něco je patně
ERROR\n";
Die("Zprávičky nebudou");
endif;
switch ($co)
{
case "p":
$result = mysql("milan", "select * from okatalog where logof<>'' and datzavod'' and
ABS(TO_DAYS(NOW()) - TO_DAYS(datzavod)) <= 7 order by datzavod");
break;
default:
$result = mysql("milan", "select * from okatalog where logof<>'' and datzavod>now() order by datzavod");
}
$pocet = mysql_NumRows($result);
echo "";
$j=0;
while ($j<$pocet):
echo "| ";
Policko($j,$result);
echo " | ";
$j++;
if ($j<$pocet) Policko($j,$result);
echo " | ";
$j++;
if ($j<$pocet)Policko($j,$result);
echo " |
";
$j++;
endwhile;
echo "
";
switch ($co)
{
case "p":
$result = mysql("milan", "select * from okatalog where logof='' and datzavod0 order by datzavod DESC");
break;
case "d":
$result = mysql("milan", "select * from okatalog where logof='' and
ABS(TO_DAYS(NOW()) - TO_DAYS(datzavod)) <= 7 order by datzavod");
break;
default:
$result = mysql("milan", "select * from okatalog where logof='' and datzavod>now() order by datzavod");
}
$pocet = mysql_NumRows($result);
$i = 0;
while ($i<$pocet):
$datum1=mysql_Result($result, $i, 'datzavod');
$datum2=mysql_Result($result, $i, 'datkon');
$datkonani= IntVal(Substr($datum1,8,2)).".".IntVal(Substr($datum1,5,2)).".".Substr($datum1,0,4);if ($datum2>0) $datkonani=$datkonani."-".IntVal(Substr($datum2,8,2)).".".IntVal(Substr($datum2,5,2)).".".Substr($datum2,0,4);
echo " ".mysql_Result($result, $i, 'nadpis').": ".$datkonani." - ".mysql_Result($result, $i, 'textces').
"
";
$i++;
endwhile;
mysql_Close();
?>
email: webmaster@orienteering.cz