Iam building a website based on php and mysql and that can store sales accounts.
Now i have a main table called sales; which contains columns price, shop, modelnumber etc,
and i also have table for each modelnumber.
nd their is an option in the website to remov certain item from stock.. nd their i enter the product model number.
what i want is that, a query which will delete the records with this specific model number from sales table, as well as other tables;;
PLEASE GIVE ME SOME IDEAA
Now i have a main table called sales; which contains columns price, shop, modelnumber etc,
and i also have table for each modelnumber.
nd their is an option in the website to remov certain item from stock.. nd their i enter the product model number.
what i want is that, a query which will delete the records with this specific model number from sales table, as well as other tables;;
PLEASE GIVE ME SOME IDEAA