merhaba mysql dosyasindan her kategoriye ayit son eklenmis 5 postu cekmek isdiyorum normalinde son eklenen postlari ceken kodu var elimde ben elimde olan kodlari sizlere vereyim belki daha yardimci olur



son eklenenlerin hepsini ceken kod

<?
if(!empty($keyword))
{
$keyw="&keyword=".urlencode($keyword);
}
$i=0;

while($obj=mysql_fetch_object($result))
{
$title=$obj->title;
$title=stripslashes($title);
$blog=$obj->blog;
$blog=stripslashes($blog);
$id=$obj->blogsid;
$title=stripslashes($title);
$title = substr($title, 0, 99) . "";
$newpage = string_to_underscore_name($title);
$username=$obj->username;
$username=stripslashes($username);

$title2="<a class='title1' href='$username-$id.php' title='$title'>$title</a>";
$id=$obj->blogsid;
if(strlen($contributor)>100)$contributor=substr($c ontributor,0,100)."..";else $contributor=$contributor."..";
$i++;

?>
Buda tablosu

CREATE TABLE `blogs` (
`blogsid` bigint(15) unsigned NOT NULL auto_increment,
`username` varchar(255) NOT NULL default '',
`bbackground` varchar(255) NOT NULL default '',
`pagecolor` varchar(10) NOT NULL default '',
`blog` longtext,
`metak` longtext NOT NULL,
`metad` longtext NOT NULL,
`metat` longtext NOT NULL,
`numviews` int(10) unsigned default '0',
`upldate` datetime default NULL,
`updated` datetime NOT NULL default '0000-00-00 00:00:00',
`numemails` int(10) unsigned default '0',
`numprints` int(10) unsigned default '0',
`numsaved` int(10) unsigned default '0',
`categoryid` int(10) unsigned default NULL,
`title` varchar(100) default NULL,
`memadsen` varchar(255) NOT NULL default '',
`shopadsen` varchar(255) NOT NULL default '',
`yahoadsen` varchar(255) NOT NULL default '',
`contributor` varchar(100) default NULL,
`imp` varchar(255) NOT NULL default '',
`status` smallint(1) NOT NULL default '0',
PRIMARY KEY (`blogsid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;
--
-- Tablo döküm verisi `blogs`
INSERT INTO `blogs` (`blogsid`, ``username`, bbackground`, `pagecolor`, `blog`, `metak`, `metad`, `metat`, `numviews`, `upldate`, `updated`, `numemails`, `numprints`, `numsaved`, `categoryid`, `title`, `memadsen`, `shopadsen`, `yahoadsen`, `contributor`, `imp`, `status`) VALUES (19, 'alper', '', 'white', buraya ekledigim icerik cikiyor , '', '', '', 'Alper Ozkan', '4', 1),
--


Buda kategori ceken kod

<?
$sql="select * from blogcategory ORDER BY catname ASC";
$res=mysql_query($sql);
while($obj=mysql_fetch_object($res))
{
$groupname=$obj->catname;
$cid=$obj->categoryid;
if($cid==$catid)$img="<img src='$domain/images/$openfoldercolor'>";else $img="<img src='$domain/images/$closedfoldercolor'>";
?>
<tr class="altbg2" valign="middle">
<td width="4%" height="25" align="left" >&nbsp;</td>
<td height="25" align="left" class="normal">
<? print "<a href='$groupname.php' title='$groupname'>$groupname</a>(".getNumdrinks($cid).")";?>