Citat:
Ursprungligen postat av PaLL3
Jag körde denna istället;
Kod:
$result = mysql_query("select itemid from entity_attributes e where(select count(*) from entity_attributes where itemid = e.itemid and attributeid = 280) = 1 and (select count(*) from entity_attributes where itemid = e.itemid and attributeid = 276) = 1");
while($row = mysql_fetch_array($result)) $list .= $row['ItemID'] . ',';
mysql_query("delete from entity_attributes where itemid in ($list)");
Funkade inte heller... |
Kod:
$result = mysql_query("select distinct itemid from entity_attributes e where attributeid= 276 OR attributeid=280");
while($row = mysql_fetch_assoc($result))
$list[] = $row['itemid'];
mysql_query("delete from entity_attributes where itemid in (" . implode(',',$list) . ")");
Ser ingen skillnad i detta mot vad du komplicerat?