inserting data in multiple tables

[ferhanz]

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
[e-mail]

[Erkilite]

for multiple records i usually use this method.

mysql_query('SET AUTOCOMMIT=0;',$dblink);

if(mysql_query('INSERT....',$dblink)){
  if(mysql_query('INSERT....',$dblink)){
    if(mysql_query('INSERT....',$dblink)){
       $record_inserted=true;
       mysql_query('COMMIT;',$dblink);
    }
  }
}

if($record_inserted==false) mysql_query('ROLLBACK;',$dblink);

mysql_query('SET AUTOCOMMIT=1',$dblink);

while the above code isn't exact, you can get the idea.

as far as deleting them from all dbs, i usually use and InnoDB and not MyISAM, that way you can declare a foreign key and the db will automatically delete the associated rows from other tables.

full text search? take a look at http://www.mysql.com/doc/en/Fulltext_Search.html

[ferhanz]

thanks for the reply..
can u tell me what are the advantages or disadvantages of using MyIsam or other types...n which type u recommend for the table structure that i have

[Erkilite]

read here, might help a little.

http://forums.devshed.com/archive/t-74147