function form_search(){//ÊÃéÒ§¿Ñ§¡ìªÑè¹âªÇì¿ÍÃìÁ¤é¹ËÒ
// àÅ×Í¡°Ò¹¢éÍÁÙÅ
mysql_select_db($dbname) or die("àÅ×Í¡°Ò¹¢éÍÁÙÅäÁèä´é");
// ¤ÓÊÑè§ SQL áÅÐÊÑè§ãËé·Ó§Ò¹
#$sql = "select * from $tblname where name like '%$search%' or description like '%$search%' or url like '%$search%'"; // ¡Ó˹´¤ÓÊÑè§ SQL à¾×èÍáÊ´§¢éÍÁÙÅ
$str = "$search";
list($search1,$search2,$search3) = explode(" ",$str);
#echo "$search1 $search2 $search3";
if ($search1){
$sql="SELECT * FROM $tblname where keyword like '%$search1%' or description like '%$search1%'";
}
if($search2){
$sql="SELECT * FROM $tblname where keyword like '%$search1%' or keyword like '%$search2%' or description like '%$search1%'or description like '%$search2%'";
}
if($search3){
$sql="SELECT * FROM $tblname where keyword like '%$search1%' or keyword like '%$search2%' or keyword like '%$search3%' or description like '%$search1%'or description like '%$search2%'or description like '%$search3%'";
}
Load balance : Server 04
