Project Smart: Project Management Templates Articles and Events

April 9, 2012 § Leave a comment

A very helpful and useful website Click here to go to Project Smart or visit http://www.projectsmart.co.uk
Project Smart

Advertisements

Quick way to Use FB Like and Twitter Share

December 14, 2011 § Leave a comment

If you ever want to place a FB Like button/Twitter share in your website just do the following thins
For FB

<a href="http://www.facebook.com/plugins/like.php?href=URL_TO_LIKE">Like</a>

Twitter
<a href="http://twitter.com/home?status=URL_TO_SHARE" title="Twitter" target="_blank">Twitter</a>

GROUP_CONTACT another mysql magic

September 20, 2011 § Leave a comment

I was wondering how to get repeated rows in to columns. For eg I have to show marks scored by a student for each subject on a specific Term. Initially it displayed as

Subject | Exam | Mark | Term
——————————
Music | TEST1 | 85 | One
Dance | TEST1 | 90 | One
Music | TEST2 | 80 | One

I want it as follows:

Subject | Exam | Mark | Term
——————————————
Music | TEST1, TEST 2 | 85, 80 | One
Dance | TEST1 | 90 | One

I got this solutions


SELECT subject.name, group_concat( exam.name ) AS exam, group_concat( mark.marks ) AS marks
FROM marks mark
LEFT JOIN subjects subject ON xxxxxxxxxxxxxxxxxxxxx
LEFT JOIN marks mark ON xxxxxxxxxxxxxxxxxxxx
LEFT JOIN exams exam ON xxxxxxxxxxxxxxxxxxxx
LEFT JOIN terms_info term ON xxxxxxxxxxxxxxxxxxxxx
WHERE mark.stud_id =69
GROUP BY subject.name
ORDER BY exam.name

Summary
Use group_concat on the field which should be merged (in my case it is exam and mark ) then use a GROUP BY on respective field

Joomla strict standards error

August 12, 2011 § 1 Comment

If you get any errors saying Strict Standards, just after installing Joomla 1.6 +, do the following.. in php.ini set
error_reporting = E_ALL & ~E_STRICT
and in configuration.php ( can be found in root folder of your joomla installation ) set
public $error_reporting = '6135';

Hope this help !!

Drupal whitepage issue

June 7, 2011 § Leave a comment

If you ever faced such a situation, while you do a custome theme development try the follwing things, it helped me

      Clear your browser cache
      Move the newly added themes folder from sites/all/themes to a temporary location
      Update the table variable and change the value of theme_default to s:10:”garland”;
      truncate the tables cache, cache_block, cache_filter, cache_forum, cache_menu, cache_page, cache_update

Nice time …

YII Framework Vs Zend Framework

February 12, 2011 § Leave a comment

Can YII be a tough competitor for Zend it has been heard that the implementation of YII is much easier as compared to ZFE
YII
ZFE

Useful tutorial on Zend Framework

February 10, 2011 § Leave a comment

Zend framework Tutorial
It contains code snippet from zend website, however the code explained here in detail.