<?php

// SQL call where custom product attrib 'promo' == 1

$pcollection = Mage::getModel('catalog/product')->getCollection()
            ->addAttributeToSelect('*')
            //->addAttributeToFilter('sku',array('like' => '%ABC%'))
            ->addAttributeToFilter('promo', '1');
foreach($pcollection as $pp)
{
    // method 1
    $_promoProduct = $pp->_data;

    Zend_Debug::dump($_promoProduct); 
    die();
 
    // method 2
    $url = $pp->getProductUrl();
    $name = $this->htmlEscape($pp->getName());
    $img_src = $pp->getThumbnailUrl(325, 215);
    $price = number_format($pp->getPrice(), 2);
    // etc
}

php

1

Magento: SQL filter by custom product attrib

<?php

// SQL call where custom product attrib 'promo' == 1

$pcollection = Mage::getModel('catalog/product')->getCollection()
            ->addAttributeToSelect('*')
            //->addAttributeToFilter('sku',array('like' => '%ABC%'))
            ->addAttributeToFilter('promo', '1');
foreach($pcollection as $pp)
{
    // method 1
    $_promoProduct = $pp->_data;

    Zend_Debug::dump($_promoProduct); 
    die();
 
    // method 2
    $url = $pp->getProductUrl();
    $name = $this->htmlEscape($pp->getName());
    $img_src = $pp->getThumbnailUrl(325, 215);
    $price = number_format($pp->getPrice(), 2);
    // etc
}

copy | embed

• magento, 
• mysql, 
• products

SELECT 
      MONTHNAME(createDt) AS month,
      YEAR(createDt) AS year,
      COUNT(*) AS total
FROM tracking
GROUP BY MONTH(createDt), YEAR(createDt)
ORDER BY id

sql

1

Count Monthly/Yearly Totals in MySQL

SELECT 
      MONTHNAME(createDt) AS month,
      YEAR(createDt) AS year,
      COUNT(*) AS total
FROM tracking
GROUP BY MONTH(createDt), YEAR(createDt)
ORDER BY id

copy | embed

• count, 
• database, 
• db, 
• mysql, 
• select

// use found_rows() as a sql function
mysql> SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name
    -> WHERE id > 100 LIMIT 10;
mysql> SELECT FOUND_ROWS();

sql

1

Use found_rows() in MySQL

// use found_rows() as a sql function
mysql> SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name
    -> WHERE id > 100 LIMIT 10;
mysql> SELECT FOUND_ROWS();

copy | embed

• database, 
• db, 
• mysql, 
• select