May 31, 2013

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 […]
May 16, 2013

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 […]
May 16, 2013

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 […]
January 20, 2011

Using Join in Update Query

  update solvents,Answers left join solvents.`Solvent` on Answer set t.`Answer_ID` = Answers.Answer_ID where Answers.Question_ID = 2;  
December 15, 2010

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 […]
October 14, 2010

MySQL Regexp to match a number from comma separated list of numbers

I have found regexp select statements useful for databases which have fields of comma-separated numbers. If I need to select all rows with a given number in such a comma-separated list, a regular expression using word boundries would work:   […]
This website uses cookies to provide necessary website functionality, improve your experience and analyze our traffic. By using our website, you agree to our Privacy Policy and our cookies usage.