MySQL: Use of GROUP after ORDER BY
Just came across a MySQL query simple problem and I was thinking it would be too simple for me to solve.
But it wasn’t like that. The query made me realize, I’m still missing some basic rules of query even after years on working on MySQL. It was about the use of GROUP BY and ORDER BY in the query.
To make [...]
The Tomb of Quide-e-Azam Muhammad Ali...
Quid-e-Azam Muhammad Ali Jinnah, the founder of Pakistan (25 Dec, 1976 – 11 Sep, 1948), when died, buried with honored in Karachi. Their grave area later converted into a big tomb that later became the landmark for Pakistan especially Karachi. The tomb was built quite big in size that it can easily be seen fro [...]
Raining … In Karachi
Karachi, the largest city of Pakistan, is a bit less fortunate when it comes to monsoon raining.
Raining always fascinate Karachites because here the total season last for less than even a month. Though they enjoy cloudy weather in whole August after the “hell hot” summer of June-July but still everyone [...]
Yii :: Sharing Cache keys between con...
Cache is important for any web or console app to save time in fetching data from the databases.
Yii offers a built in cache mechanism with a variety of choosing different cache engines, e.g. Sqlite, Memcache, API etc.
Sometimes, you also require a console application to integrate the data with the web app. This may b [...]
My another PHP class nominated at PHP...
Few days before I wrote about the class , I recently submitted to PHPClasses.org.
The class was successfully approved on the PHPClasses and it has been nominated for the “Innovation Award”, a regular monthly competition arranged by PHPClasses.
So If you are registered at PHPClasses.org, you can vote to t [...]
Take a look at “WordPress”...
https://play.google.com/store/apps/details?id=org.wordpress.android
I have just started using this WordPress Android app. Like the web interface, the app’s interface is so neat and usable that one would only want to create post from mobile device only. The menu is clearly defined and all main options can be se [...]
TV remote control inventor Eugene Pol...
http://www.bbc.co.uk/news/world-us-canada-18164200 The inventor of TV Remote Control “Eugene Polley” of “Zenith” died at the age of 97. Definitely Eugene’s invention made him one of the greatest inventor on 20th century. Today wheb we get beneited of hundreds of channels would never be f [...]
BASIC Language Parser – My new ...
Update: This class won a 3rd rank overall for the month May 2012 at PHPClasses.org.
Recently, I was stuck in a situation where I wanted to have my own small conditional language and its parser.
I only wanted to execute the conditions using “IF THEN ELSE”. I came up with this idea and it worked. Althoug [...]
Yii Framework : How to change the DB ...
How to change the DB connection in Yii models at runtime.
After you have generated the Yii model, you need to add a parent method from CActiveRecord “getDbConnection()”.
This method is actually resposible to return the database connection. In this method, you need to create a DB connection. If you use
re [...]
A Story of Lycos Customer Support
Recently my 14 years old “hotmail” account was blocked as someone managed to access it to send lots of spam email. MSN blocked my account and asked me to send a code that has been sent to my email account which was at lycos mail. I was surprised to see that my lycos email was no more and I had to re signu [...]
