 |
 |
 |
 |
 |
| Author |
Message |
hetes
Joined: 17 Apr 2007
Posts: 36
Location: Hungary |
|
 MySQL error in search |
 |
I get this error message, when i search e.g. John Williams:
 | | Notice:
mysql_query(): MySQL 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 '%john 'williams%' or full like %john 'williams%'' at line 4 in /host/path/wwwroot/mypage.php: include on line 144
in /host/prepend/prepend.php(187) : system created function on line 36
Notice:
mysql_query(): MySQL 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 '%john 'williams%'' at line 4 in /host/path/wwwroot/mypage.php: include on line 144
in /host/prepend/prepend.php(187) : system created function on line 36 |
On mypage on line 144
| | <?php
include("dirname/head.php");
?>
....
<?php
if ($do == 'search'){ include $cutepath.'/search.php'; }
?> |
If i search just John or Williams, i get the results correctly.
Is it a bug or my server's bad settings?
Any idea? 
|
|
| Mon Sep 17, 2007 4:22 pm |
  |
|
Guest
|
| |
|
Please login to hide the ads.
|
|
|
|
|
scottdallas
Joined: 04 May 2006
Posts: 1943
Location: US |
|
| |
|
The script (for reasons I don't understand) doesn't seem to like to search multiple words. I've never seen it flip out that bad though. There's a multiple word search add-on in 'Additional Downloads' but it doesn't allow you to set a $template.. the search template seems hard-coded inside of the search plugin. I haven't taken much time to see how to adjust it's template.. it works similarly to CuteNews search out of box. I'm sure it won't be too hard to manipulate, then you should be able to search John Williams 
_________________
www.scottdizzle.com uses cnr 
last update: 07-22-08: 8:30 pm |
|
| Mon Sep 17, 2007 6:35 pm |
  |
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum
|
|
|
 |
 |
|
