Colin Guthrie wrote: > The ON DELETE CASCADE option is key here... "DELETE FROM students > where student_id=1" will remove all traces of that student from the > db... all the course they've attended, all the instructors who have > taught them etc. keeps things nice and tidy without having to put the > structure in your code all over the place. > > Col > Why would you want to delete the instructors when deleting the student? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php