Mysql array search (IN) yardım.

$multisigorta = implode(",",$_POST[multisigorta]);
$multiindirim = implode(",",$_POST[multiindirim]);
$Kampanya=$SP_DB->Cok("SELECT * FROM kampanya WHERE sonlanma > '".date("Y-m-d")."' and kamp_firma IN (".$multisigorta.") and kamp_meslek IN (".$multiindirim.") ORDER BY sonlanma ASC");

CREATE TABLE `kampanya` (
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `seo` text NOT NULL,
  `detay` longtext NOT NULL,
  `baslangic` date NOT NULL,
  `sonlanma` date NOT NULL,
  `ip` varchar(15) NOT NULL,
  `time` datetime NOT NULL,
  `durum` int(1) NOT NULL default '0',
  `company` int(11) NOT NULL,
  `kamp_firma` varchar(11) NOT NULL,
  `kamp_meslek` varchar(11) NOT NULL,
  `kamp_resim` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

-- 
-- Tablo döküm verisi `kampanya`
-- 

INSERT INTO `kampanya` VALUES (1, 'Acıbadem ve Ak Sigorta Hayat Sigortası', 'Acibadem-ve-Ak-Sigorta-Hayat-Sigortasi', '', '2012-11-26', '2012-11-28', '', '2012-11-27 11:03:33', 1, 0, '1,2', '1,2,3', 'images/kampanya/1354007013-Acibadem-ve-Ak-Sigorta-Hayat-Sigortasi.jpg');

INSERT INTO `kampanya` VALUES (2, 'Anadolu Hayat ve Ankara Sigorta Dask Sigortası', '', '2012-11-30', '2012-12-31', '', '2012-11-27 11:07:09', 1, 0, '3,4', '3,4,5', 'images/kampanya/1354007229-Anadolu-Hayat-ve-Ankara-Sigorta-Dask-Sigortasi.jpg');

INSERT INTO `kampanya` VALUES (3, 'Axa Oyak Konut Sigortası', 'Axa-Oyak-Konut-Sigortasi', '', '2012-11-28', '2012-12-25', '', '2012-11-27 11:17:54', 1, 0, '6', '5', 'images/kampanya/1354007874-Axa-Oyak-Konut-Sigortasi.jpg');

$multisigorta = array(1,2,3); 
$multiindirim = array(2,3); 

foreach($multisigorta as $deger){
    $sql_firma[] = 'kamp_firma LIKE %'.$deger.'%';
}

foreach($multiindirim as $deger){
    $sql_indirim[] = 'kamp_meslek LIKE %'.$deger.'%';
}

$sql = 'SELECT * FROM kampanya WHERE sonlanma > '.date("Y-m-d").' AND '.implode(" AND ", $sql_firma).' AND '.implode(" AND ", $sql_indirim).' ORDER BY sonlanma ASC';


$Kampanya=$SP_DB->Cok($sql);

 kamp_firma IN (1) and kamp_meslek IN (2)

$multisigorta = array(1,2,3); 
$multiindirim = array(2,3); 

foreach($multisigorta as $deger){
    $sql_firma[] = 'kamp_firma LIKE %'.$deger.'%';
}

foreach($multiindirim as $deger){
    $sql_indirim[] = 'kamp_meslek LIKE %'.$deger.'%';
}

$sql = 'SELECT * FROM kampanya WHERE sonlanma > '.date("Y-m-d").' AND '.implode(" AND ", $sql_firma).' AND '.implode(" AND ", $sql_indirim).' ORDER BY sonlanma ASC';


$Kampanya=$SP_DB->Cok($sql);