Просмотр поста

.
Guccifer

нужен переделать это на 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>';
   


}