var timeStamp = Date.UTC('year','month','date', 'hour','min','seconds')/1000;
var timeStamp = Date.parse(dateObj/1000);

var datSelected = new Date(this.timeStamp * 1000);

public function generateRandomPwd($num = 7)
{
$char = "023456789abcdefghijkmnopqrstuvwxyz!@#$%^&*";
srand((double)microtime()*1000000);
$i = 0;
$pass = '' ;
while ($i <= $num) {
$num = rand() % 33;
$tmp = substr($char, $num, 1);
$pass = $pass . $tmp;
$i++;
}
return $pass;
}

public function getBrowserType(){

$sUserBrowserAgent = '';

if (ereg('OPERA(/| )([0-9].[0-9]{1,2})', strtoupper($_SERVER["HTTP_USER_AGENT"]), $log_version)) {
$sUserBrowserAgent = 'OPERA';
} else if (ereg('MSIE ([0-9].[0-9]{1,2})', strtoupper($_SERVER["HTTP_USER_AGENT"]), $log_version)) {
$sUserBrowserAgent = 'IE';
} else if (ereg('OMNIWEB/([0-9].[0-9]{1,2})', strtoupper($_SERVER["HTTP_USER_AGENT"]), $log_version)) {
$sUserBrowserAgent = 'OMNIWEB';
} else if (ereg('MOZILLA/([0-9].[0-9]{1,2})', strtoupper($_SERVER["HTTP_USER_AGENT"]), $log_version)) {
$sUserBrowserAgent = 'MOZILLA';
} else if (ereg('KONQUEROR/([0-9].[0-9]{1,2})', strtoupper($_SERVER["HTTP_USER_AGENT"]), $log_version)) {
$sUserBrowserAgent = 'KONQUEROR';
} else {
$sUserBrowserAgent = 'OTHER';
}

return $sUserBrowserAgent;

}

SELECT U.username, U.user_id, SR.section_id, U.access, count( DISTINCT SR.section_id ) AS section_count
FROM `users` U
LEFT JOIN `survey_replies` SR ON ( U.user_id = SR.user_id )
WHERE U.access >1
GROUP BY U.user_id
ORDER BY SR.section_id