inserting records in multiple tables

well not much experienced with php/mysql..i have just started a project in which i have to maintain a members database ...the members fall in several categories and then those categories have further sub categories.. so i have got 3 tables using the table type MyIsam using version 4 mysql

1. Member
2. Category
3. Sub Category

now when inseting data through forms i have to insert it directly in 3 tables...i know how to insert it single table but how can i insert it in more then 1 in a single statement?

secondly help me out in deleting those records from multiple tables through a single statement

in the last how can implement a full text search in php ?


Thanks in Advance
Farhan Nawazish
webmaster@hrdn.net

Thread moved from 'PHP Coding' to 'Programming Theory' by CodeKadiya.

Reason:

You can't. You must use three SQL statements to insert into three tables.



Again, you can't. DELETE only works on one table at a time.



This is probably easier done in MySQL. See this page.

Actually you can delete from multiple tables at one time. If you use InnoDB table w/foreign key constraints, you can also do cascading updates/deletes.