• 16-08-2009, 14:07:00
    #19
    Üyeliği durduruldu
    <?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
  • 16-08-2009, 14:19:34
    #20
    Veritabanı 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 .= "&nbsp;<font class='mainnavbreak'>|</font>&nbsp;";
        }
        $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
    #21
    Üyeliği durduruldu
    sunu indirde bi bakıver hoca ya siteye yükledim yapamadim dellencem valla


    http://www.uploadyeri.com/index.php/...yeni-klasr.rar
  • 19-08-2009, 19:22:33
    #22
    Üyeliği durduruldu
    yokmu arkadaslar konuyu anlayip cözebilecek kimse biz cözemedik ne hikmetse