<?php
$result = mysql_query('SELECT `id`, `adi` FROM `yazilar` where kat=17 ORDER BY `id` DESC LIMIT 5');
while ( $row = mysql_fetch_assoc($result) )
echo '<A title=' . $row['adi'] . ' HREF=/oyun/'.$row['id'].'-'.seo($row['adi']).'.html>' . $row['adi'] . '</a><br>
';
?>
bu kod sorunsuz sekilde cekiyor normalde ama buna stilleri ekleyemedim ben
ufak bir sorun yardim
21
●1.105
- 16-08-2009, 14:19:34Veritabanı ayarlarını, kolon adlarını ve seo adresini falan kendine göre düzenleyip dene su sefer söz oldu

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <?php //Veritabanı Ayarları Başlangıç $kullaniciadi ="root"; $sifre =""; $host ="localhost"; $veritabani =""; $baglan=mysql_connect($host,$kullaniciadi,$sifre); mysql_select_db($veritabani,$baglan); //Veritabanı Ayarları Bitiş if(!$ptitle) $ptitle = $site_name; if(!$selected) $selected = "HOME"; // main nav $main_nav = array(); $main_nav[] = array('pagecode'=>'HOME', 'title'=>'ana sayfa', 'url'=>$site_path.'index.php'); $main_nav[] = array('pagecode'=>'CATEGORIES', 'title'=>'kategoriler', 'url'=>$site_path.'categories.php'); $main_nav[] = array('pagecode'=>'BROWSE', 'title'=>'buraya göz atın', 'url'=>$site_path.'browse.php'); $main_nav[] = array('pagecode'=>'SEARCH', 'title'=>'arama', 'url'=>$site_path.'search.php'); $main_nav[] = array('pagecode'=>'RANDOM', 'title'=>'karma sözler', 'url'=>$site_path.'random-joke.php'); $main_nav[] = array('pagecode'=>'SUBMIT', 'title'=>'söz ekle', 'url'=>$site_path.'submit-joke.php'); $main_nav[] = array('pagecode'=>'CONTACT', 'title'=>'iletisim', 'url'=>$site_path.'contact-us.php'); // 'JOKES' left menu contents // this must be x items of less $jokes_nav = array(); $jokes_nav[] = array('title'=>'güzel sözler', 'url'=>$site_path.'random-joke.php'); $jokes_nav[] = array('title'=>'aşk sözleri', 'url'=>$site_path.'jokes_knock-knock-jokes.php'); $jokes_nav[] = array('title'=>'hazir mesajlar', 'url'=>$site_path.'jokes_music-jokes.php'); $jokes_nav[] = array('title'=>'kisa aşk sözleri', 'url'=>$site_path.'jokes_internet-jokes.php'); $jokes_nav[] = array('title'=>'kisa güzel sözler', 'url'=>$site_path.'jokes_lawyer-jokes.php'); $jokes_nav[] = array('title'=>'en güzel sözler', 'url'=>$site_path.'jokes_marriage-jokes.php'); $jokes_nav[] = array('title'=>'Yo Momma Jokes', 'url'=>$site_path.'jokes_yo-momma-jokes.php'); $jokes_nav[] = array('title'=>'Cowboy Jokes', 'url'=>$site_path.'jokes_cowboy-jokes.php'); $jokes_nav[] = array('title'=>'Accountant Jokes', 'url'=>$site_path.'jokes_accountant-jokes.php'); $jokes_nav[] = array('title'=>'Women Jokes', 'url'=>$site_path.'jokes_women-jokes.php'); $jokes_nav[] = array('title'=>'Men Jokes', 'url'=>$site_path.'jokes_men-jokes.php'); $jokes_nav[] = array('title'=>'More...', 'url'=>$site_path.'categories.php'); ?> <html> <head> <title><?php echo $ptitle; ?> - <?php echo $site_name; ?></title> <META http-equiv="Content-Type" content="text/html; charset=iso-8859-9"> <META NAME="keywords" CONTENT="<?php echo $meta_keys; ?>"> <META NAME="description" CONTENT="<?php echo $meta_desc; ?>"> <link rel="stylesheet" href="<?php echo $site_path; ?>styles.css"> </head> <body style="background: #444444 url('<?php echo $site_path; ?>images/main-bg.jpg') repeat-x; margin:0px;"> <table width="759" cellpadding="0" cellspacing="0" align="center"><tr><td width="5" valign="top"><img src="<?php echo $site_path; ?>images/top-left.jpg" width="5" height="138"></td><td width="749" valign="top"> <table width="100%" cellpadding="0" cellspacing="0"> <tr> <td style="background-image:url(<?php echo $site_path; ?>images/header.jpg);" height="138" width="749" valign="top"> <table width="100%" cellpadding="0" cellspacing="0"> <tr> <td style="padding-top:83px;padding-left:88px;" class="slogan"> <?php echo $site_slogan; ?> </td> </tr> <tr> <td style="padding-top:19px;padding-left:8px;"> <?php $nav = ""; foreach($main_nav AS $this_nav) { if($this_nav[pagecode] == $selected) $nav .= "<b>"; $nav .= "<a href='".$this_nav[url]."' class='mainnav'>".$this_nav[title]."</a>"; if($this_nav[pagecode] == $selected) $nav .= "</b>"; $nav .= " <font class='mainnavbreak'>|</font> "; } $nav = substr($nav, 0, strlen($nav)-49); echo $nav; ?> </td> </tr> </table> </td> </tr> <tr> <td valign="top" style="background: #FFFFFF url('<?php echo $site_path; ?>images/body-bg.gif'); border:1px solid #FFFFFF;"> <table width="100%" cellpadding="0" cellspacing="0"> <tr> <td width="162" valign="top"> <table width="162" cellpadding="0" cellspacing="0"> <tr> <td colspan="2"> <img src="<?php echo $site_path; ?>images/spacer.gif" height="10"> </td> </tr> <tr> <td width="10"> <img src="<?php echo $site_path; ?>images/spacer.gif" width="10"> </td> <td width="152" valign="top" style="background: url('<?php echo $site_path; ?>images/menu-jokes.gif'); padding-left:8px;" width="152" height="245"> <br class="smallBr"><br class="smallBr"> <font class="menuheader">KATEGORİ ::</font> <br><br class="smallBr"><br class="smallBr"><br class="smallBr"><br class="smallBr"> <table width="90%" cellpadding="0" cellspacing="0"> <?php $tracker = 0; foreach($jokes_nav AS $this_item) { echo "<tr><td width='11' style='padding-top:4px;' class='menuitem'><img src='".$site_path."images/menu-item-on.gif' width='6' height='6' name='img".$tracker."' id='img".$tracker."'></td><td style='padding-top:4px;' class='menuitem'><a href='".$this_item[url]."' class='menuitem' onMouseOver=\"img".$tracker.".src='".$site_path."images/menu-item-off.gif';\" onMouseOut=\"img".$tracker.".src='".$site_path."images/menu-item-on.gif';\">".strtoupper($this_item[title])."</a></td></tr>"; $tracker++; } ?> </table> <br class="smallBr"><br class="smallBr"> <font class="menuheader">KATEGORİ ::</font> <br><br class="smallBr"><br class="smallBr"><br class="smallBr"><br class="smallBr"> <table width="90%" cellpadding="0" cellspacing="0"> <?php $sorgu=mysql_query("SELECT * FROM tabloadi ORDER BY kolon"); $tracker = 0; while ($ks=mysql_fetch_array($sorgu)){ echo "<tr><td width='11' style='padding-top:4px;' class='menuitem'><img src='".$site_path."images/menu-item-on.gif' width='6' height='6' name='img".$tracker."' id='img".$tracker."'></td><td style='padding-top:4px;' class='menuitem'><a href='".$this_item[url]."' class='menuitem' onMouseOver=\"img".$tracker.".src='".$site_path."images/menu-item-off.gif';\" onMouseOut=\"img".$tracker.".src='".$site_path."images/menu-item-on.gif';\">".$ks["kategoriadi"]."</a></td></tr>"; $tracker++; } ?> </table> </td> </tr> </table> <table width="160" cellpadding="0" cellspacing="0"> <tr> <td colspan="2"> <img src="<?php echo $site_path; ?>images/spacer.gif" height="10"> </td> </tr> <tr> <td width="10"> <img src="<?php echo $site_path; ?>images/spacer.gif" width="10"> </td> <td width="150" valign="top" style="background: url('<?php echo $site_path; ?>images/menu-search.gif'); padding-left:8px;" width="150" height="93"> <br class="smallBr"><br class="smallBr"> <font class="menuheader">ARAMA ::</font> <br><br class="smallBr"><br class="smallBr"><br class="smallBr"><br class="smallBr"> <table width="90%" cellpadding="3" cellspacing="0"> <form method='POST' action='search.php'> <tr><td width='30'><b>ara:</b></td><td><input name='c' type='text' class='smallform' style='width:60px; background-color: #F5DB8B;'></td></tr> <tr><td></td><td><input name='submitme' type='submit' value='arayın' class='smallform'></td></tr> </form> </table> </td> </tr> </table> <br> </td> <td> <img src="<?php echo $site_path; ?>images/spacer.gif" width="4"> </td> <td valign="top"> <table width="570" cellpadding="6" cellspacing="0" style="background: #FFFFFF url('<?php echo $site_path; ?>images/body-bg-<?php echo strtolower($selected); ?>.jpg') no-repeat top right; border:1px solid #CCCCCC; margin-top:11px;" height="100%"> <tr> <td valign="top" width="100%" style="padding-top:6px;"> - 16-08-2009, 14:29:34Üyeliği durduruldusunu indirde bi bakıver hoca ya siteye yükledim yapamadim dellencem valla

http://www.uploadyeri.com/index.php/...yeni-klasr.rar

