belirli karakter kadar mysqlden veri çekmek - Sayfa 2

07-01-2011, 19:57:50

#10

Sırrı

İsterseniz msn adresimi ekleyin isterseniz buraya dosyayı ekleyin kontrol edeyim

07-01-2011, 19:59:10

#11

batuhankok

ekledim...

<head>
<META http-equiv=content-type content=text/html;charset=iso-8859-9>
<link rel="stylesheet" type="text/css" href="batuhan.css">
</head>



 

 <table width="765" align="right" border="0">
  <tr>
	<td>
     

 <?php
 include ("vt.php");
$sor=mysql_query("select * from yazilar ORDER BY id DESC limit 1");
while($yaz=mysql_fetch_array($sor)){
$id=$yaz['id'];
$baslik=$yaz['baslik'];
$hit=$yaz['hit'];
$tarih=$yaz['tarih'];
$yazi = mb_substr($yaz['yazi_metni'],0,300,'UTF-8').'...';
 echo "<tr>
    <td><a href=makaleoku.php?id=$id>$baslik</a></td><br>
    </tr><tr><td>$yazi</td>
    ";
    
    }
    echo '
  </tr>
</table>';
?>

	</td>
   </tr>
 </table>







 <table width="765" align="right" border="0">
  <tr>
    <td align="center"><b><font color="#000071" size="4">SON YAZILAR &nbsp;&nbsp;&nbsp;&nbsp;</font></b></td>
  </tr>
 </table>

<table width="765" border="0" align="right">
  <tr>
    <td><b><font color="#000071"><u>Makale Baslığı</u></font></b></td>
    <td><b><font color="#000071"><u>Tarih</u></font></b></td>
    <td><b><font color="#000071"><u>Yazar</u></font></b></td>
    <td><b><font color="#000071"><u>Hit</u></font></b></td>
    <td><b><font color="#000071"><u>Kategori</u></font></b> </td>
  </tr>
 <?php
 include ("vt.php");
$sor=mysql_query("select * from yazilar ORDER BY id DESC limit 10");
while($yaz=mysql_fetch_array($sor)){
$id=$yaz['id'];
$baslik=$yaz['baslik'];
$hit=$yaz['hit'];
$tarih=$yaz['tarih'];
$katid=$yaz['katid'];

$katcek=mysql_fetch_array(mysql_query("select * from kategori where id='$katid'"));
$katadi=$katcek['katadi'];
 echo "<tr>
    <td><a href=makaleoku.php?id=$id>$baslik</a></td>
    <td>$tarih</td>
    <td>Batuhan Kök</td>
    <td>$hit</td>
    <td><a href=kategori.php?id=$katid>$katadi</a></td>
    ";
    
    }
    echo '
  </tr>
</table>';
?>

07-01-2011, 20:14:40

#12

Sırrı

$yazi = substr($yaz['yazi_metni'],0,300).'...';