<?

  mysql_connect( "localhost" ,  "guest" ,  "guest" ); 
  mysql_select_db( "guest" );

$query =  "select * from news order by id desc" ; 
$result = mysql_query($query) or die (mysql_errno(). ": " .mysql_error());
$num = mysql_num_rows($result);
if(mysql_num_rows($result) >  0 ) { 

  while ($row = mysql_fetch_array($result)) 
  { 
    $date = $row[ "date" ]; 
    $header = $row[ "header" ];
    $id = $row[ "id" ];
    $text = $row[ "text" ];
    $type = $row[ "type" ];

if ($type ==  1 ) {
$head =  "Важная" ;}
elseif ($type ==  2 ) {
$head =  "Обновление" ;}
else {
$head =  "Новость" ;}

$header = str_replace (  "[r" ,  "<b><font color=red>" , $header );
$header = str_replace (  "[g" ,  "<b><font color=green>" , $header );
$header = str_replace (  "[" ,  "<u>" , $header );
$header = str_replace (  "]" ,  "</b></u><font color=black size=1 >", $header );

Echo  "
<table width=\"  100 %\ " border=\"  0 \ " bgcolor=\" #CACACA\ " cellpadding=\"  2 \ ">
  <tr> 
    <td bgcolor=\" #ACACAC\ " class=\" obvod\ ">$date г.</td>
    <td width=\"  73 %\ " bgcolor=\" #DFDFDF\ " class=\" obvod\ "><b>$head:</b> $header</td>
  </tr>
  <tr>
    <td width=\"  9 %\ "> </td>
    <td colspan=\"  5 \ " bgcolor=\" #DFDFDF\ " class=\" obvod\ ">   $text</td>
  </tr>
</table>
<br>
" ;
   } 
} 

?>

$l