Magento – How to check if value exists in catalog_category_product table Magento

databasemagento2query

How can I check if the value exists in catalog_category_product table Magento ?

Best Answer

$_product = Mage::getModel('catalog/product')->load(product_id);
$categoryIds = $_products->getCategoryIds();
if(in_array(category_id, $categoryIds)){
 echo "value already there!";
}
else
{
echo "value not there!";
}

Hope this will work for you.

Related Solutions

Magento – Upgrade to 1.9.2.2 – Base table or view already exists: 1050 Table ‘mage_permission_variable’ already exists

That means you already have the mage_permission_variable table in your database.
Don't delete the file instead of you can drop mage_permission_variable and mage_permission_block table then continue you upgrading process

it will do the trick....

Don't forget to backup the database before dropping those tables

Hope it helps

Magento 1.9 Database – How to Save Decimal Value in Flat Table

your latitude column (and longitude) are of type decimal(10,0).
This means you can save up to 10 digits in it and none of them are decimals.

Since you want to save 7 decimal digits and the max longitude possible is 180 and the max latitude is 90 you should make your columns look like this:

| Longitude   | decimal(10,7)    | NO   |     | NULL    |                |
| Latitude    | decimal(9,7)     | NO   |     | NULL    |                |
+-------------+------------------+------+-----+---------+----------------+

Best Answer

Related Solutions

Magento – Upgrade to 1.9.2.2 – Base table or view already exists: 1050 Table ‘mage_permission_variable’ already exists

Magento 1.9 Database – How to Save Decimal Value in Flat Table

Related Topic