- Katılım
- 25 Ocak 2008
- Mesajlar
- 117
- Açılan Konu
- 12
- Tepki puanı
- 0
- Konum
- Turkey
günaydın
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/siteadi/x.php on line 228
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 'a') AS skor FROM progs WHERE MATCH(prog, fulldesc, etiket, url_down) AGAINST(''a' at line 1
yukarıdaki hatayı nasıl düzeltebilirim? sorun nedir acaba?
php kodu aşağıdadır
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/siteadi/x.php on line 228
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 'a') AS skor FROM progs WHERE MATCH(prog, fulldesc, etiket, url_down) AGAINST(''a' at line 1
yukarıdaki hatayı nasıl düzeltebilirim? sorun nedir acaba?
php kodu aşağıdadır
PHP:
mysql_connect ($dbhost, $dbuser, $dbpass) or die (mysql_error());
@mysql_select_db ($dbname) or die (mysql_error());
$aramkont = mysql_query("select kelime from aradim where kelime = '$q'");
$aran = mysql_fetch_object($aramkont);
if($aran == 1) {
$guncelle = mysql_query("UPDATE aradim SET hit = hit + 1 WHERE kelime = '$q'");
}
else
{
$guncelle = mysql_query("INSERT INTO aradim (id, kelime, hit) VALUES (lisanssız, '$q', '1')");}
$sayfada_gosterilecek_program_sayisi = 20;
$baslangic = $_GET['baslangic'];
if($baslangic == "") $baslangic = 0;
if($kategori == 0)
{
$dnm = mysql_query("SELECT *, MATCH(prog, fulldesc, etiket, url_down) AGAINST('$q') AS skor FROM progs WHERE MATCH(prog, fulldesc, etiket, url_down) AGAINST('$q') AND status=1 ORDER BY skor DESC limit $baslangic,$sayfada_gosterilecek_program_sayisi") or die(mysql_error());
$dnm2 = mysql_query("SELECT COUNT(pid) FROM progs WHERE MATCH(prog, fulldesc, etiket, url_down) AGAINST('$q') AND status = 1 limit 200");
}
$program_sayisi=mysql_result($dnm2,0);
echo(mysql_error());
?>
