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.
SELECT DISTINCT town_name from city;
SELECT town_id, town_zip, town_name from city group by town_name;
the result also not quite accurate using DISTINCT, I still have duplicate data.
Keep learn, get new stuff [...]

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”
Hmm, I’m totally agree
I have to mysql server that serve almost [...]

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..