$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 EnglishHindiPunjabiChineseSELECT GROUP_CONCAT(Language) As Languages FROM CountryLanguage;Output will be: English,Hindi,Punjabi,ChineseSELECT GROUP_CONCAT(Language SEPARATOR '-') As Languages FROM CountryLanguage; Output will be:
English-Hindi-Punjabi-Chinese