MySql & PHP date format Part 2 –- AS clauses, array associative and IF statement

1. MySQL DATE_FORMAT() with AS clauses to change the clumsy column name.
2. Use PHP IF statement.
3. PHP mysql_fetch_assoc()for keeping fetch data array.
4. PHP array[].