Find browser using PHP

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;

}

MYSQL - LEFT JOIN query

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

Regular expression to remove the file name from the SERVER vairables

$sScriptPath = preg_replace("@/(\w){1,}.php(\w)?$@","",$_SERVER['SCRIPT_NAME']);
$sActionPage = "https://".$_SERVER['HTTP_HOST'].$sScriptPath."/member.php?action=add"

Embed media player in HTML page

Javscript Date comparison with current date

var d=new Date();
var form_date = "01-08-2009";
var split_date = form_date.split("-");
var added_timestamp = Number(d.setMonth(split_date[0]-1,split_date[1]));
var form_date = parseInt(split_date[0])+"/"+parseInt(split_date[1])+"/"+parseInt(split_date[2])+" "+d.getHours()+":"+d.getMinutes()+":"+d.getSeconds();


var timestamp = Number(new Date());
if(form_date < timestamp){
alert(Please select the date greater than the current date!);

}

MYSQL FOREIGN KEY

To create mysql foreign key the table engine must be InnoDB and the version is 5.
Command
------
CREATE TABLE `bookings` ( id INT , customer_id INT , FOREIGN KEY `customer_id` REFERENCES customer(id))ENGINE=INNODB;
ALTER TABLE `bookings` ADD CONSTRAINT FOREIGN KEY `customer_id` REFERENCES customer(id);

Highligt table row using Javascript

if(document.getElementById(id).hasChildNodes()){
var ctds = document.getElementById(id).getElementsByTagName('TD');
for(var chld = 0; chld < ctds.length ;chld++ ){
ctds[chld].className ='selectedFromList';
}
}
if(document.getElementById(id).parentNode){
var ctrs = document.getElementById(id).parentNode.getElementsByTagName('TR');
for(var chld = 0; chld < ctrs.length ;chld++ ){
if(ctrs[chld].id != id){
var ctds = ctrs[chld].getElementsByTagName('TD');
for(var chltr = 0; chltr < ctds.length ;chltr++ )
ctds[chltr].className = 'noteSelectedNorm';
}
}
}