Archief - SQL & PHP: sql erro op searchpagina

$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);

 You have an error in your SQL syntax near 'test AND goedkeuring = 1 ' at line 1

<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>

$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);

You have an error in your SQL syntax near ''zoekterm' AND goedkeuring = 1 ' at line 1

$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));