Kod:
// benzer konular baslangici by Kript0
$lim="5"; // benzer konulardaki en?ok baslik sayisi
$kelime=" ".$ft_title."";$stra = $kelime;$stra = str_replace(" ","&kel[]=",$stra);
parse_str($stra, $benzer);$kel0 = $benzer['kel'][0];
$sorgu=sed_sql_query("SELECT * FROM `sed_forum_topics` WHERE `ft_title` LIKE '%".$kel0."%'".$kel1."".$kel2."".$kel3."".$kel4."".$kel5."".$kel6."".$kel7." limit 0,".$lim."");
$krip=mysql_num_rows($sorgu);
if(1 < $krip){
echo "<table width=\"100%\" border=0 class=cells><tr><td class=coltop height=10 colspan=3 align=center><span>BENZER KONULAR</span></td></tr><tr><td class=fbar height=10 align=center><span>Konu</span></td><td align=center><span>Konuyu Baslatan</span></td></tr>";
while ($krip3 = mysql_fetch_object($sorgu)) {
$krip1 = mysql_fetch_object(mysql_query("SELECT * FROM `sed_users` WHERE `user_id` like '".$krip3->ft_firstposterid."' limit 1"));
echo "<tr><td bgcolor=#fbfbfb><span class=gensmall><a href=\"forums.php?m=posts&q=$krip3->ft_id\">$krip3->ft_title</a></span></td><td align=center><a href=\"users.php?m=details&id=$krip1->user_id\">$krip1->user_name</td></tr>";}
echo "</table>";}
// benzer konular sonu by Kript0
$lim="5"; // benzer konulardaki en?ok baslik sayisi
$kelime=" ".$ft_title."";$stra = $kelime;$stra = str_replace(" ","&kel[]=",$stra);
parse_str($stra, $benzer);$kel0 = $benzer['kel'][0];
$sorgu=sed_sql_query("SELECT * FROM `sed_forum_topics` WHERE `ft_title` LIKE '%".$kel0."%'".$kel1."".$kel2."".$kel3."".$kel4."".$kel5."".$kel6."".$kel7." limit 0,".$lim."");
$krip=mysql_num_rows($sorgu);
if(1 < $krip){
echo "<table width=\"100%\" border=0 class=cells><tr><td class=coltop height=10 colspan=3 align=center><span>BENZER KONULAR</span></td></tr><tr><td class=fbar height=10 align=center><span>Konu</span></td><td align=center><span>Konuyu Baslatan</span></td></tr>";
while ($krip3 = mysql_fetch_object($sorgu)) {
$krip1 = mysql_fetch_object(mysql_query("SELECT * FROM `sed_users` WHERE `user_id` like '".$krip3->ft_firstposterid."' limit 1"));
echo "<tr><td bgcolor=#fbfbfb><span class=gensmall><a href=\"forums.php?m=posts&q=$krip3->ft_id\">$krip3->ft_title</a></span></td><td align=center><a href=\"users.php?m=details&id=$krip1->user_id\">$krip1->user_name</td></tr>";}
echo "</table>";}
// benzer konular sonu by Kript0
http://www.cotonti-tr.com/benzer.....-16s.html
isteklerinizi en iyi ?ekilde zaman bulduk?a haz?rl?yorum sizlerinde g?rd??? gibi bu nedenle sadece sab?rl? olman?z yeterli.
https://seditio.com.tr/eski1/benz.....d310.html
Forumdaki benzer konular? g?sterir.
Sayfalardaki Benzer Ba?l?klar? g?sterir.
son mesaj 23 dakika ?nce
sorguyu tek tek sorgulatt?m ama yinede bu ar?zay? verdi
Fatal error : SQL error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
direk bunu okut i?te.
Kod:
ALTER TABLE sed_pages ADD fulltext(page_title);
ALTER TABLE sed_forum_topics ADD fulltext(ft_title);
ALTER TABLE sed_forum_topics ADD fulltext(ft_title);
page_title
);# Etkilenen sat?rlar: 71
ALTER TABLE sed_forum_topics ADD FULLTEXT (
ft_title
);# MySQL bo? bir sonu? k?mesi d?nd?rd? ( s?f?r sat?r).
diyor
t?kla izle
son mesaj 3 dakika ?nce
ger?e hostta linux mu?
son mesaj 55 saniye
Fatal error : SQL error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1