06. september 2006 - 19:58Der er
19 kommentarer og 1 løsning
Søgning på min side
Hejsa
Jeg sidder og laver en søgeside til min hjemmeside, men kan ikke rigtig få det til at virke. Jeg får fejlen: 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 'LIKE headline = '%g%' AND news = '%g%' ORDER BY id DESC LIMIT' a
For at give jer lidt kode, som starter fra linje 85:
if(!empty($keyword)) { if($news == ' checked') { echo '<h3>Nyheder</h3>'; if($way == 'Indeholder') { $like = 'LIKE headline = \'%'.$keyword.'%\' AND news = \'%'.$keyword.'%\''; } else { $like = 'LIKE headline = \'%'.$keyword.'\' AND news = \'%'.$keyword.'\''; } $query = mysql_query("SELECT * FROM partysite_news $like ORDER BY id DESC LIMIT") or die(mysql_error()); if(mysql_num_rows($query) == 0) { echo 'Vi kunne desværre ikke finde nogle nyheder som passede på dine kriterier!'; } else { //udskriv } }
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 'LIKE = '%gf%' AND news = '%gf%' ORDER BY id DESC' at line 1
KOden var denne; $like = 'headline LIKE \'%'.$keyword.'%\' AND news LIKE \'%'.$keyword.'%\'';
Fejlen: 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 'LIKE '%j%' AND news LIKE '%j%' ORDER BY id DESC' at line 1
Okay nu får jeg denne fejl: 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
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 'LIKE headline = '%d' AND news = '%d' ORDER BY id DESC LIMIT' at
Synes godt om
Slettet bruger
07. september 2006 - 00:13#9
hehe griner...
if($way == 'Indeholder') { $like = "LIKE headline '%".$keyword."%' AND LIKE news '%".$keyword."%'"; } else { $like = "LIKE headline '%".$keyword."' AND LIKE news '%".$keyword."'"; }
KOden nu: if($way == 'Indeholder') { $like = "headline LIKE '%".$keyword."%' AND LIKE news '%".$keyword."%'"; } else { $like = "headline LIKE '%".$keyword."' AND LIKE news '%".$keyword."'"; }
Fejlen: 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 'LIKE news '%hgj' ORDER BY id DESC LIMIT' at line 1
if($way == 'Indeholder') { $like = "headline LIKE '%".$keyword."%' AND news LIKE '%".$keyword."%'"; } else { $like = "headline LIKE '%".$keyword."' AND news LIKE '%".$keyword."'"; }
if($way == 'Indeholder') { $like = "headline LIKE '%".$keyword."%' AND news LIKE '%".$keyword."%'"; } else { $like = "headline LIKE '%".$keyword."' AND news LIKE '%".$keyword."'"; }
FEJL:
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
Jamen det havde jeg selv fjernet på et tidspunkt :S Også kom jeg vist til at sætte det på igen, men tak :)
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.