delete multiple query
| From: | peppe | Date: | Mon, 29 Nov 2004 14:49:25 +0000 |
| Subject: | delete multiple query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-37443@lists.php.net to get a copy of this message | ||
Hi guys ,
Maybe this question was posted earlier but I could not find it
I have couple of tables
tblCountry
tblCity
tblStreet
tblUser
I have foreign keys
tblUser.street_FK = tblStreet.street_id
tblStreet.city_FK = tblCity.city_id
tblCity.country_FK = tblCountry.country_id
I have PHP Version 4.3.2 and MySql 3.23.49
I need when I delete country a want to delete cities under that country
streets under that city and users under streets
thanx