SelectDatabase($DatabaseName); //nastavení databáze
// $db->SQLCommand('SET character_set_results='.$CharSET);
// $db->SQLCommand('SET character_set_connection='.$CharSET);
// $db->SQLCommand('SET character_set_client='.$CharSET);
$db->SQLCommand('SET NAMES '.$CharSET);
// $db->SQLCommand('SET CHARACTER SET '.$CharSET);
function GetHtmlChar($TestString)
{ // BEGIN function GetHtmlChar
$TestString=str_replace("\r", "", $TestString);
$TestString=str_replace("\n", "
", $TestString);
//str_replace("\r", "
", $Line[2])
$TestString = htmlspecialchars($TestString);
return $TestString;
} // END function GetHtmlChar
echo '";
echo '
Obec Zděchov - novinky
http://obec.zdechov.net
Aktuality webové stránky obec.zdechov.net
cs
Tue, 31 Jul 2007 14:06:06 +0200
maron2@centrum.cz
20';
$sql = "SELECT * FROM news order by 3 DESC LIMIT 10";
$ID = $db->SQLCommand($sql);
while($Line = mysql_fetch_array($ID)) {
echo '
-
'.$Line['Name'].'
'.$Line['Date'].'
'.$Line['User'].'
http://obec.zdechov.net
'.GetHtmlChar($Line['Text']).'
';
} //
echo '
';
?>