Maybe somebody has a simpler way of deleting foreign records (since mysql doesn't have foreign keys < 4.0)....
select from table1
left outer join table2
on x=y
and y is null
while $row = fetch_object
$ids[] = $row->ID
implode($ids);
...
delete from table1
where ID in ($ids)
you get the idea - no big deal, but after the umpteenth time coding it 🙂....