Another tip :
“Don’t use DISTINCT when you have or could use GROUP BY”
I prefer to use GROUP BY than DISTINCT since I can retrieve more field.

Click here to continue reading..

Today Google show me interesting link :
Top 10 SQL Performance Tips – MySQL Forge
Right now it’s consist of 84 tips, I can understand some of them but many I don’t know what it means
one of them :
“partition your database when you have real data”

Click here to continue reading..

PHP ternary operator isn’t beautiful for reading reason
It’s also make confuse, but for the sake of simple it’s OK
Syntax :
( expr1 ) ? ( expr2 ) : (expr3)
If expr1 return true, then it evaluates to ( expr2 )If expr1 return false, then it evaluates to ( expr3 )
it’s similar to if..else
if(true) {
code 1
}
else [...]

Click here to continue reading..

Joomla is very popular CMS, it’s easy to setup and require only working php and mysql installation.
A problem may arise when your administrator password lost or forgot.
Can I recover my admin password or create a new one ?
It’s common question in "Setting your own Content Management System" workshop.
Use php md5() function !
Here’s the steps [...]

Click here to continue reading..