Gecko [ 122.154.134.11 ]

Name	Size	Permission
block-Who-is-Where.php	4.77 KB	-rw-r--r--
block-Who_is_Online.php	2.83 KB	-rw-r--r--
block-car-today.php	3.16 KB	-rw-r--r--
block-happybirthday.php	1.19 KB	-rw-r--r--
block-meeting-today.php	3.66 KB	-rw-r--r--
block-permission-today.php	5.44 KB	-rw-r--r--
block-person.php	14.11 KB	-rw-r--r--
block-work-today.php	10.63 KB	-rw-r--r--
countdown.php	5.22 KB	-rw-r--r--
index.html	0 B	-rw-r--r--

Code Editor : block-happybirthday.php

<?php

//สุขสันต์วันเกิด
//echo "<img src=\"images/birthday.gif\" border=0 width=250 height=135>";
$db2sql = "SELECT a.department_id, a.department_name, a.phone, a.fax, a.email, a.URL, b.organization_id, b.org_position, b.org_name, b.org_nickname, b.org_birth, b.org_tel, b.org_email, b.username, b.password FROM ".$prefix."_o_department a LEFT JOIN ".$prefix."_o_organization b ON a.department_id=b.org_department WHERE b.status !='' and a.status !='' and b.org_birth like '%-$m_today-$d_today' ";
$db2query = mysqli_query($connect2,$db2sql);
$num_rows = mysqli_num_rows($db2query);
if ( $num_rows != '0' ){
	echo "สุขสันต์วันเกิด ".$today_thai." จำนวน ".$num_rows." ท่าน";
	echo "<OL>";
	while ($db2result = mysqli_fetch_array($db2query)){
		echo "<li>".$db2result['org_name']." "
				.$db2result['org_position']."</li>"
				.$db2result['department_name']."";
	}
	echo "</OL>";

}else{
	echo "สุขสันต์วันเกิด ".$today_thai." - ไม่มีข้อมูล - ";
}
?>

${this.title}

Code Editor : block-happybirthday.php