нужен переделать это на PDO
$harf = $_GET['harf'];
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `dream` WHERE `title` LIKE '".$harf."%' ORDER BY `title` ASC"),0);
$req = mysql_query("SELECT * FROM `dream` WHERE `title` LIKE '".$harf."%' ORDER BY `title` ASC LIMIT $start, $kmess");
$i = 0;
while ($res = mysql_fetch_array($req)) {
$i++;
echo '<div class="menu"><a href="index.php?id='.$res['id'].'">'.$res['title'].'</a><br/><small>'.mb_substr(trim($res['text']), 0, 100).'...</small></div>';
}