PHP MySQL Query checker.

//So if you want to save your users some time for typing new queries , you may want to check this out.

function query_tester($query) {
    //check if query is limited
    if (strpos($sql, “LIMIT”)) {
        $array = explode(“LIMIT” ,  $query‘);
        $query = $array[0] .  ’ LIMIT 1′;
    } else {
        $query =  $query . ‘ LIMIT 1′;
    }
    $result = mysql_query($query);
    $count = mysql_num_rows($result);
    if($count > 0) {
        return true;
    } else {
        return false;
    }
}//function end

So now we have the needed function lets try an example.

$q =mysql_real_escape_string( $_GET['q']);  //search key;

$query = “SELECT * FROM comment WHERE text LIKE  ’%$q%’ ”;
if(query_tester($query)) {
    $result = mysql_query($query);
    //query exists do whatever you want;
} else {
    //in else statement may be done something like this;
    $array = explode(” ” , $q);
    $second_query = ”SELECT * FROM comment WHERE text LIKE  ’%$array[0]%’ ”;
    $result = mysql_query($second_query); //do default stuff;
}

Simple as that.