php - Check if an id exists in a table before adding it to another table -
i'm doing small thing like feature see on facebook. way i'm doing this. have table called products contains products people can like . (stripped down): id | prodname | status (0=clear, 1=blocked) ---------------------------------------------------------- 1 | philips food processor | 0 2 | le sharp knife | 0 3 | ye cool fridge | 0 comes `likes` table this: id | prodname | prodid | userid -------------------------------------------- 1 | philips food processor | 1 | 1 2 | le sharp knife | 2 | 1 3 | ye cool fridge | 3 | 1 4 | ye cool fridge | 3 | 2 i need check, before adding likes table, if product id actually exists in products table , status = 0. lot of php code. way using sql? possible? using foreign keys or that? i'm using innodb table type. you can conditional insert . product 6 , user 7: insert likes (prodname, prodid, userid) select prodname...