deleting records from multiple tables

[ferhanz]

i have got 3 tables

1) student:
student_id
student_name
student_address

2)subjects
subject_id
student_id
subject_name

3)hobbies
hobby_id
student_id
hobby_name

what i want is that when i delete the record from student table it should delete all the records of that id from subjects and hobbies table, i am using phpmyadmin for creating tables and the type of the table is default MyISAM

Thanks

Farhan Nawazish

[johnnyv]

You will need to issue three seperate delete querys.

$sql = "delete from student where student_id = $blah";

mysql_query($sql,$connection) or die("couldn't delete from student: $sql");

$sql =  "delete from subjects where student_id = $blah";

mysql_query($sql,$connection) or die("couldn't delete from subjects: $sql");

$sql =  "delete from hobbies where student_id = $blah";

mysql_query($sql,$connection) or die("couldn't delete from hobbies: $sql");