$query="SELECT name.*, drama.*, sdarot.* FROM name, drama, sdarot WHERE name.main LIKE ='%".$search."%' OR drama.main LIKE ='%".$search."%' OR sdarot.main='%".$search."%'
$query="SELECT name.*, drama.*, sdarot.* FROM name, drama, sdarot WHERE name.main LIKE '%".$search."%' OR drama.main LIKE '%".$search."%' OR sdarot.main='%".$search."%'