I have a code that I want to delete fields in multiple tables. It doesn't error but it doesn't work. Any Ideas?
if ($submit == "DELETE")
{
$strSql = "DELETE FROM tshirts, category WHERE (shirtname = '$DelShirtname') and where(tshirts.catID = category.catID)";
mysql_query ($strSql,$db) or die ("Cannot Delete.");
}
echo "Tshirt has been deleted";
mysql_close($db);
?>