no script eu tenho que deletar dados de um banco de dados proprio
mais o problema é que tenho que fazer varias exclusões
eu consegui fazer funcionar normalmentel porem na gambiarra que eu fiz faz o sistema ficar um pouco
lento por favor me indiquem uma maneira mais facil de deletar varios objetos de uma tabela
o meu método foi
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='40803'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='40804'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='40805'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='40806'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='40807'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='40808'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='40809'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='40810'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='40811'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='40812'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='40813'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='40814'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='40815'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='40816'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='40817'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='40818'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43448'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43449'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43450'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43451'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43452'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43453'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43454'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43455'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43456'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43471'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43376'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43377'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43378'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43379'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43380'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43381'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43382'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43383'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43384'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43385'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43386'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43387'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43388'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43389'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43390'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43391'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43392'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43393'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43394'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43395'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43396'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43397'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43398'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43399'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43400'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43401'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43402'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43403'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43404'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43405'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43406'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43407'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43408'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43409'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43410'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43411'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='43412'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44462'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44478'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44479'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44480'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44481'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44482'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44483'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44484'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44485'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44486'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44487'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44488'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44489'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44490'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44491'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44492'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44493'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44494'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44495'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44496'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44497'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44498'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44499'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44500'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44501'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44502'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44503'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44504'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44505'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44506'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44507'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44508'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44509'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44510'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44511'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44512'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44513'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44514'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44515'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44516'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44517'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44518'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44519'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44523'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44524'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='44525'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49421'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49422'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49423'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49424'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49428'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49429'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49430'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49431'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49437'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49438'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49439'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49440'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49458'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49459'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49460'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49461'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49462'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49463'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49464'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49465'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49466'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49467'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49468'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49469'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49470'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49471'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49472'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49473'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49474'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49475'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49476'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49477'");
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49478'");
preciso de uma maneira que use só um delete tipo
$sql = mysql_query("DELETE FROM items WHERE owner_id='$owner' AND item_id='49478 , 49478 , 49478 , 49478,'");
que funcione
obrigado des de já
