$date1 = date('2011-11-01');
$date2 = date('2011-11-09');
echo (strtotime($date2) - strtotime($date1))/(60*60*24);
8 would be answer
$date2 = date('2011-11-09');
echo (strtotime($date2) - strtotime($date1))/(60*60*24);
8 would be answer
Language is column name and
CountryLanguage is table name
English
Hindi
Punjabi
Chinese
SELECT GROUP_CONCAT(Language) As Languages FROM CountryLanguage;
Output will be:
English,Hindi,Punjabi,Chinese
SELECT GROUP_CONCAT(Language
SEPARATOR '-'
) As Languages FROM CountryLanguage;
Output will be:
English-Hindi-Punjabi-Chinese