Help for this page

Select Code to Download


  1. or download this
    my $mquery =  "INSERT INTO Search_Results ( search_id, page_id )
             SELECT ?, P.id
    ...
             WHERE MATCH ( P.pgdata ) AGAINST ( ? IN BOOLEAN MODE )
                  AND P.doc_id = D.id
                  AND D.dir_id = DI.id ";
    
  2. or download this
    my $mquery =  "INSERT INTO Search_Results ( search_id, page_id )
                      SELECT ?, P.id
    ...
        $mquery .= "AND P.id = SR.page_id AND SR.search_id = ? ";
        push @query_args, $ref_sid;
    }