TalkPHP - View Single Post - Delete records from multiple tables? (PHP, MySQL)

shoaibmunir · 06-23-2009, 02:59 PM

I have to delete records in multiple table i have only main category id "1001" and i want to delete all sub categories and products.

Database Structure

Main Category Table:-

MainID = 1001
MainName = HP

Sub Category Table:-

MainID = 1001
SubID = 2001
SubName = laptops

Products Table:-

SubID = 2001
ProID = 3001
ProName = HP G60t series

_______________

any idea?

06-23-2009, 02:59 PM	#1 (permalink)
shoaibmunir The Wanderer Join Date: Jun 2009 Location: Dubai, UAE Posts: 23 Thanks: 2	Delete records from multiple tables? (PHP, MySQL) I have to delete records in multiple table i have only main category id "1001" and i want to delete all sub categories and products. Database Structure Main Category Table:- MainID = 1001 MainName = HP Sub Category Table:- MainID = 1001 SubID = 2001 SubName = laptops Products Table:- SubID = 2001 ProID = 3001 ProName = HP G60t series _______________ any idea?