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
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