sql запрос скидывающий все товары на складе в 0 - [VM1] Управление товарами, атрибутами, типами, ценами

UPDATE
	    `vm_product`
	SET
	    `product_in_stock`=0

UPDATE
	    `vm_product`
	SET
	    `product_in_stock`=0
       WHERE  id_товара=тут какая то цифра ID товара одного!!

function TovariVNol(&$csviregistry) {
	$db = $csviregistry->GetObject('database');
	$csvilog = $csviregistry->GetObject('logger');
	$q = "SELECT product_id FROM #__vm_product";
	$db->query($q);
	
	
	if ($db->num_rows() > 0)
	{
		while ($db->next_record())
		{
			$q = "UPDATE #__vm_product
				SET product_in_stock = '0'";
			$db->query($q);
			$csvilog->AddStats('information', 'здесь какой то текст');
		}
	}
	else $csvilog->AddStats('information', 'текст о том что нет нулевых');

             return true;

}

function TovariVNol(&$csviregistry)
{
	$db = $csviregistry->GetObject('database');
	$csvilog = $csviregistry->GetObject('logger');

	$query = "SELECT product_id
	FROM #__vm_product
	WHERE product_in_stock > '0'";
	
	$db->query($query);

	while ($db->next_record())
	{
		$foundids = $db->f('product_id').',';
	}

	if ($db->num_rows() > 0)
	{
		while ($db->next_record())
		{
			$q = "UPDATE #__vm_product
				SET product_in_stock = '0'
				WHERE product_in_stock = '".$foundids."'";
			$db->query($q);

			$csvilog->AddStats('incorrect', 'Field ID '.$db->f("product_id").' has not been removed');
		}
	}
	else $csvilog->AddStats('information', 'No orphaned fields found');

	return true;
}

function TovariVNol(&$csviregistry)
{
	$db = $csviregistry->GetObject('database');
	$csvilog = $csviregistry->GetObject('logger');

	$query = "SELECT product_id
	FROM #__vm_product
	WHERE product_in_stock > '0'";
	
	$db->query($query);

	//while ($db->next_record())
	//{
	//	$foundids = $db->f('product_id').',';
	//}

	if ($db->num_rows() > 0)
	{
		while ($db->next_record())
		{
			$q = "UPDATE #__vm_product
				SET product_in_stock = '0'
				WHERE product_id = '".$db->f("product_id")."'";
			$db->query($q);

			$csvilog->AddStats('information', 'Field ID '.$db->f("product_id").' has not been removed');
		}
	}
	else $csvilog->AddStats('information', 'No orphaned fields found');

	return true;
}

function TovariVNol(&$csviregistry)
{
	$db = $csviregistry->GetObject('database');
	$dbclean = $csviregistry->CloneObj($db);
	$csvilog = $csviregistry->GetObject('logger');

	$q = "SELECT product_id FROM #__vm_product
		WHERE product_in_stock > '0'";
	$db->query($q);
	if ($db->num_rows() > 0)
	{
		while ($db->next_record())
		{
			$q = "UPDATE  #__vm_product
				SET product_in_stock = '0'
				WHERE product_id = '".$db->f("product_id")."'";

			if ($dbclean->query($q))
				$csvilog->AddStats('deleted', 'Field ID '.$db->f("product_id").' has been removed');
			else $csvilog->AddStats('incorrect', 'Field ID '.$db->f("product_id").' has not been removed');
		}
	}
	else
		$csvilog->AddStats('information', 'No orphaned fields found');
	return true;
}