I am trying to make search function

to search title name

and the option to search Creation Time, Update Time, Board ID

The structure of the table is

id||board||title||owner||status||priority||views|| createtime||updateuser||updatetime||bumptime||bump s

I just really need advice on what to use to do this.

select what_you_need
from your_table
where title like '%the_search_term%'

Now, what do you mean by

and the option to search Creation Time, Update Time, Board ID

?

WHERE updatetime (is between search time) OR creationtime (is between search time) OR boardid = searchid

but the user will have the OPTION to search them and if one is set search with that, and if 2 then search with 2 of them

and I don't want to have like 5/6 different SQL querys in if statments

Just create your sql query depending of what the user sends to you...

PHP Code:

$searchTerm==isset($_GET['searchTerm'])?addslashes($_GET['searchTerm']):false;  
$updateTime=isset($_GET['updateTime'])?$_GET['updateTime']:false;  //search in update time ?
$upTimeS=isset($_GET['upTimeS'])?$_GET['upTimeS']:false;  //if yes, from wich time
$upTimeE=isset($_GET['upTimeE'])?$_GET['upTimeE']:false;  //to which time

$creationTime=isset($_GET['creationTime'])?$_GET['creationTime']:false;  //search by creation time
$creaTimeS=isset($_GET['creaTimeS'])?$_GET['creaTimeS']:false;  //if yes, from wich time
$creaTimeE=isset($_GET['creaTimeE'])?$_GET['creaTimeE']:false;  //to which time

$boardId=isset($_GET['boardId'])?$_GET['boardId']:false;  //search by board id ?
$sql=<<<SQL
select what_you_need
from your_table
where title like '%$searchTerm%'
SQL;
if($updateTime!==false){
     $sql.="or updatetime between '$upTimeS' and '$upTimeE' \n";
}
if($creationTime!==false){
     $sql.="or creationTime between '$creaTimeS' and '$creaTimeE' \n";
}
if($boardId!==false){
  $sql.="or boardid =$boardId";
} 


Thank you, see I would have never thought to use it like that.