Son konular - Title karakter limiti gerekiyor ?

Son güncelleme: 02.04.2011 10:21
  • Aşağıda ki kodlarla son konuları göstericem ancak başlıklara limit gerekiyor.



    $ozelsql = $db->query_read("SELECT
    post.postid, post.pagetext, thread.threadid, thread.title, thread.dateline, thread.forumid, thread.firstpostid, thread.dateline, thread.views, thread.visible
    FROM " . TABLE_PREFIX . "thread AS thread
    LEFT JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = thread.firstpostid)
    WHERE thread.forumid in (327,329) AND thread.visible = 1
    ORDER BY thread.dateline DESC LIMIT 0, 10
    ");

    while ($gthread = $db->fetch_array($ozelsql))
    {

    $montrey2 = $gthread['threadid'];
    $montrey3 = $gthread[title];
    $albumsarki .= "<a href=\"showthread.php?t=$montrey2\" /><a href=\"showthread.php?t=$montrey2\">$montrey3</a><br>";
    }
#02.04.2011 10:21 0 0 0