How to use PDO-MySQL with PHP

PDO is a PHP extension that allows multiple PHP's database connections by creating a single cohesive interface. It allows code portability and compatibility across various platforms. It can be considered as a database access layer providing a uniform method of access to multiple databases. By using PDO you can switch between different databases and platforms […]

Magento Admin Fix for CSS and JS Not Loading

After transferring the magento store to new server and database you might find that the magento admin is not loading the CSS and JS files. Because of that, the design would look out of order and the categories pages would not display the products.   To fix this, you have to run the following SQL […]

Alternate Method For Magento Incremental Update

In order to maintain all your tables and data the way it is, you often require to perform an incremental update for magento, doing it otherwise might make some of your data obsolete. Here is a simple step by step guide to perform magento incremental update:       First you have to back up […]

MySql query – Grouping by first character in field value

MySQL select statement for querying records grouped by first character of value SELECT case when SUBSTRING( UPPER(`title`) from 1 for 1) between ‘0’ and ‘9’ then ‘0-9’ else SUBSTRING( UPPER(`title`) from 1 for 1) end as letter, count(title) AS occurences FROM `tablename` GROUP BY letter ORDER BY letter;   Result: letter occurence 0-9 2 A […]