-
17-04-2004, 01:38 #1
SQL & PHP: sql erro op searchpagina
wat klopt er niet aan deze constructie?
dit is de errorPHP Code:$key_searchstring = "1";
if (isset($_POST['searchstring'])) {
$key_searchstring = (get_magic_quotes_gpc()) ? $_POST['searchstring'] : addslashes($_POST['searchstring']);
}
mysql_select_db($database_members, $members);
$query_searchstring = sprintf("SELECT * FROM zoekertjes WHERE MATCH (titel, artikel) AGAINST $key_searchstring AND goedkeuring = 1 ", $key_searchstring);
en dit is het formCode:You have an error in your SQL syntax near 'test AND goedkeuring = 1 ' at line 1
Code:<form action="/zoekertjes_search3.php" method="post" name="zoek2" id="zoek2"> <input name="searchstring" type="text" class="formulier" id="searchstring" size="30" /> <input name="Submit" type="submit" class="formulier" value=" Zoek " /> </form>thx in advanceno votes
-
-
17-04-2004, 02:18 #2
probeer zo eens
PHP Code:$key_searchstring = "1";
if (isset($_POST['searchstring'])) {
$key_searchstring = (get_magic_quotes_gpc()) ? $_POST['searchstring'] : addslashes($_POST['searchstring']);
}
mysql_select_db($database_members, $members);
$query_searchstring = sprintf("SELECT * FROM zoekertjes WHERE MATCH (titel, artikel) AGAINST '$key_searchstring' AND goedkeuring = 1 ", $key_searchstring);
no votes
-
17-04-2004, 12:12 #3
nee, werkt ook niet dit is de error:
Code:You have an error in your SQL syntax near ''zoekterm' AND goedkeuring = 1 ' at line 1
thx in advanceno votes
-
17-04-2004, 12:39 #4
ik heb nu gekeken op mysql.com en dit is zowat het eniste dat ik kan bedenken....
PHP Code:$key_searchstring = "1";
if (isset($_POST['searchstring'])) {
$key_searchstring = (get_magic_quotes_gpc()) ? $_POST['searchstring'] : addslashes($_POST['searchstring']);
}
mysql_select_db($database_members, $members);
$query_searchstring = sprintf("SELECT * FROM zoekertjes WHERE MATCH (titel, artikel) AGAINST ('$key_searchstring' AND goedkeuring = 1 , $key_searchstring));
no votes
