Allowing action if table is empty?

[petey]

I am building a links / URL manager and have a question I need some help with. (MySQL / PHP)

I have two tables, a category table, and a link table

When a user wishes to delete a category heading, I want the code to check whether the link table is empty first - so that no links become "lost" when their parent category is deleted.

Any ideas?

[Anon]

Why not do a select against the links table for this category and make sure the row count for the result is 0?