delete from two tables in one query

[eluser]Otemu[/eluser]
Hi,

If your table has a foreign key constraint and are related, you could have a delete cascade on update, basically if you delete a field in one table it delete on the other.

You could use what TheFuzzy0ne check out codeigniter transactions

and finally you could use a join if the tables are related.

Thanks hope that helps