1. #1
    SuPeRfLy's Avatar
    Registered
    17/07/02
    Posts
    98
    iTrader
    0
    Mentioned
    0 Post(s)
    Reputation
    0/0

    SQL & PHP: sql erro op searchpagina

    wat klopt er niet aan deze constructie?

    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); 
    dit is de error
    Code:
     You have an error in your SQL syntax near 'test AND goedkeuring = 1 ' at line 1
    en dit is het form
    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 advance
    no votes  

  2. #2
    0n3Liner's Avatar
    Registered
    10/09/03
    Location
    daar
    Posts
    1,198
    iTrader
    0
    Mentioned
    0 Post(s)
    Reputation
    2/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  

  3. #3
    SuPeRfLy's Avatar
    Registered
    17/07/02
    Posts
    98
    iTrader
    0
    Mentioned
    0 Post(s)
    Reputation
    0/0
    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 advance
    no votes  

  4. #4
    0n3Liner's Avatar
    Registered
    10/09/03
    Location
    daar
    Posts
    1,198
    iTrader
    0
    Mentioned
    0 Post(s)
    Reputation
    2/2
    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  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Log in

Log in