<?php
function trim_text($input, $length, $end) {
$last_space = iconv_strrpos(iconv_substr($input, 0, $length,'UTF-8'), ' ','UTF-8');
$trimmed_text = iconv_substr($input, 0, $last_space,'UTF-8');
$trimmed_text .= $end;
return $trimmed_text;
}
 
 
if(isset($_GET['id']) && is_numeric($_GET['id'])) {
 $id = $_GET['id'];
}
else {
 $id = 1;
}
$con = mysql_connect("localhost","nikas","passwordas");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
mysql_select_db("database", $con);
 
$result = mysql_query("SELECT * FROM news ORDER BY ID DESC");
if(isset($_GET['full'])) {
 $result2 = mysql_query("SELECT * FROM news WHERE id='".$_GET['id']." ORDER BY id DESC'");
 $info = mysql_fetch_array($result2);
echo '<div class="rightpaneltop"><center><h4>'.$info['title'].'</h4></center></div>';
echo '<div class="rightpanel">'.$info['content'].'</div>';
}
else {
 while($info = mysql_fetch_array($result)) {
  echo '<div class="rightpaneltop"><center><h4>'.$info['title'].'</h4></center></div>';
  echo '<div class="rightpanel">'.trim_text($info['content'],125,'... [<a href="news.php?full&id='.$info['ID'].'">Read More</a>]').'</div>';
  echo "<br />";
 }
}
mysql_close($con);
?>