BetterPHP

libeco wrote:Why don't you use foreign key constraints? http://dev.mysql.com/doc/refman/5.5/en/ ... aints.html

That's what i did end up using.. I got it working.. can close this please thanks

SOLV ED

The cat_id is set whenever I click delete from the cat_list page...

i've tried...
WHERE cat_id = $cat_id
WHERE cat_id = $_GET['cat_id']
...etc, but none seem to work.. do I need to do a FOREIGN KEY or a INNER JOIN on c.id to p.cat_id ??

I'm having troubles with my blog... I have 2 tables: 1. posts(id, cat_id, title, contents, date_posted) 2. categories(id, name), and to delete the category: <a href="delete_category.php?id=<?php echo $category['id']; ?>">Delete</a> if i view the categories and try to delete one from my cat...