本文整理汇总了PHP中ResultDB函数的典型用法代码示例。如果您正苦于以下问题：PHP ResultDB函数的具体用法？PHP ResultDB怎么用？PHP ResultDB使用的例子？那么, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了ResultDB函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: ResultDB
?>
</td>
<td align="center"> <?php
$result = ResultDB($sqlAllBorn7);
$rs = mysql_fetch_array($result);
echo $rs['total'];
?>
</td>
<td align="center"> <?php
$result = ResultDB($sqlAllBorn8);
$rs = mysql_fetch_array($result);
echo $rs['total'];
?>
</td>
<td align="center"> <?php
$result = ResultDB($sqlAllBorn9);
$rs = mysql_fetch_array($result);
echo $rs['total'];
?>
</td>
<td> </td>
</tr>
<td> </td>
<td> ¤ÅÍ´»¡µÔ</td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>示例2: ResultDB
<input type="checkbox" name="cause_err17" value="[c17]">17.Å×ÁãËéÂÒ<br>
<input type="checkbox" name="cause_err18" value="[c18]">18.äÁèÁÕ¡ÒõÃǨÊͺ«éÓ<br>
<input type="checkbox" name="cause_err19" value="[c19]">19.Telephone Order<br>
<input type="checkbox" name="cause_err20" value="[c20">20.Í×è¹æ (ÃкØ) <br>
<input type="text" name="cause_err20txt" size="40"><br><br>
</td>
</tr>
<tr>
<td bgcolor="#CCFF00">ÃдѺ¤ÇÒÁÃعáç :</td>
<td colspan="5" bgcolor="#CCFF00"> </td>
</tr>
<tr align="left" valign="top">
<td colspan="6"> ->>
<?php
$sqlS_Level = "SELECT * FROM level_err ";
$resultS_Level = ResultDB($sqlS_Level);
if (mysql_num_rows($resultS_Level) > 0) {
//row
print "<select name='level_err' id='Txt-Field'>";
for ($i = 0; $i < mysql_num_rows($resultS_Level); $i++) {
//for
$rsS_Level = mysql_fetch_array($resultS_Level);
if (strlen($rsS_Level['detail']) > 105) {
$text_len105 = substr($rsS_Level['detail'], 0, 105) . "......";
} else {
$text_len105 = $rsS_Level['detail'];
}
print "<option value='" . $rsS_Level['level_code'] . "' title='" . $text_len105 . "'>" . $rsS_Level['level_code'] . "->" . $text_len105 . "</option>\n";
//print "<option onmouseover=\"this.value='onmouseover fired'\" onmouseout=\"this.value=''\" value='".$rsS_Level['level_code']."' title='".$text_len105."'>".$rsS_Level['level_code']."->".$text_len105."</option>";
//print "<option onmouseover=\"this.value='onmouseover fired'\" onmouseout=\"this.value=''\" value='".$rsS_Level['level_code']."' title='".$rsS_Level['detail']."'>".$rsS_Level['level_code']."->".$text_len105."</option>";
//print "<option onmouseover=\"this.value='onmouseover fired'\" onmouseout=\"this.value=''\" value='".$level_en."' title='".$level_text."'>".$level_en."</option>";示例3: session_start
<?php
session_start();
header("Content-type:text/html; charset=windows-874");
include "phpconf.php";
include "func.php";
conDB();
$sql = "SELECT hn,concat(pname,fname,' ',lname) as pt_name,birthday FROM patient WHERE hn='{$_REQUEST['hn']}'";
$result_Search = ResultDB($sql);
if (mysql_num_rows($result_Search) > 0) {
$i = 0;
while ($i < mysql_num_rows($result_Search)) {
//while
$rs_search = mysql_fetch_array($result_Search);
echo "<font color='yellow' size='4'><b>";
echo " ";
echo $rs_search['pt_name'];
echo " ";
/*
echo "�ѹ�Դ ";
echo " ";
echo dateThai($rs_search['birthday']);
echo "</b></font>";
*/
$i++;
}
} else {
echo "<font color='yellow' size='5'><b>";
echo " ";
echo "�������ª��ͤ�������к�";
echo "</b></font>";示例4: ResultDB
}
</script>
</head>
<body>
<div align="center">
<?php
$vn = $_GET["vn"];
$imgnum = $_GET["imgnum"];
if ($imgnum == '') {
$imgnum = "1";
} else {
$imgnum = $imgnum;
}
$sqlPe = "select * from pe_image where vn='{$vn}' ";
$resultPe = ResultDB($sqlPe);
$rsPe = mysql_fetch_array($resultPe);
//echo $rsPe['cc'];
if (mysql_num_rows($resultPe) > 0) {
if ($rsPe["image5"] != "") {
$imgall = "5";
} elseif ($rsPe["image4"] != "") {
$imgall = "4";
} elseif ($rsPe["image3"] != "") {
$imgall = "3";
} elseif ($rsPe["image2"] != "") {
$imgall = "2";
} elseif ($rsPe["image1"] != "") {
$imgall = "1";
}
if ($imgnum - 1 != "0") {示例5: elseif
</form>
<?php
} elseif ($submit_risk == "Done") {
//check botton submit
//echo "Done->department_id:$department_id ,relation_program :$relation_program �ѹ��� $sdate $smonth $syear<br>";
//echo ",subject :$subject ,detail :$risk_detail ,risk_edit_basic :$risk_edit_basic ,risk_Info_system=$risk_Info_system";
//echo "Login : ".$ip_Log;
//echo "risk_level_text=$risk_level_text ,risk_level :$risk_level ";
//echo $time_current;
$date_time_current = $syear . "-" . $smonth . "-" . $sdate . " " . $time_current;
//echo $date_time_current;
//$risk_level_all=$risk_level." : ".$risk_level_text;//echo $risk_level_all;
//check ready
//sql check
$sqlReadyData = "SELECT * FROM risk_report_web where subject='{$subject}' and risk_detail='{$risk_detail}' and report_user='{$ip_Log}' ";
$resultReadyData = ResultDB($sqlReadyData);
if (mysql_num_rows($resultReadyData) > 0) {
//row ready
echo "<center><h2>�����Ŵѧ������ա����§ҹ�ҧ�غѵԡ�ó����º��������....���ѡ����</h2></center>";
echo "<META HTTP-EQUIV='REFRESH' CONTENT='1; URL={$PHP_SELF}'>";
} else {
//row ready
//sql insert risk
$sql_Risk_insert = "INSERT INTO risk_report_web(report_date_time,department_id,subject,risk_level,relation_program,risk_detail,report_user, ";
//table name in database
$sql_Risk_insert .= "review_status,review_date_time,review_staff,review_detail,edit_basic,info_system,respond_level_depart,result_follow,all_date_review) ";
$sql_Risk_insert .= "VALUE ('{$date_time_current}','{$department_id}','{$subject}','{$risk_level}','{$relation_program}','{$risk_detail}','{$ip_Log}','N',NULL,NULL,NULL,'{$risk_edit_basic}','{$risk_Info_system}',NULL,NULL,NULL) ";
if ($subject != "" and trim($risk_detail) != "") {
//data empty
mysql_query($sql_Risk_insert) or die("�������ö�ѹ�֡������㹰ҹ��������<br><center><font color=red><h2>�Դ��ͼ������к�</h2></font><br><a href='result_login.php'>˹����ѡ</a></center>" . mysql_error());
echo "<center><h2>�ѹ�֡������㹰ҹ������ ���º��������....���ѡ����</h2></center>";示例6: date
$m = date("n");
$y = date("Y");
//date in the day ,month 05->m,5->n
$date_current = $d . " " . change_month_isThai($m) . " " . ($y + 543);
//date cuurent thai
$time_current = date(" H:i:s");
//time cuurent
//sql form id
//echo "risk_id=".$risk_id."subject=".$subject;
$sqlDetail = "SELECT m.*,right(r.level_name,length(r.level_name)-2) as n_level,h.name as depart_name,o.name as user_name ";
$sqlDetail .= "FROM medication_err m ";
$sqlDetail .= "left outer join risk_level r on left(r.level_name,1)=m.level_code ";
$sqlDetail .= "left outer join hospital_department h on h.id=m.depart_code ";
$sqlDetail .= "left outer join opduser o on o.loginname=m.user_err ";
$sqlDetail .= "where m.err_id='{$err_id}' ";
$result = ResultDB($sqlDetail);
//echo mysql_num_rows($result);
$rs = mysql_fetch_array($result);
?>
<br>
<table width="550" border="0" cellspacing="1" cellpadding="2">
<tr align="center">
<td colspan="4" bgcolor="#319ACE"><span class="headmenu">ÃÒÂÅÐàÍÕ´·Ñé§ËÁ´</span></td>
</tr>
<tr>
<td bgcolor="#319ACE"> id : </td>
<td colspan="3" bgcolor="#FFFFCC"> <?php
echo $rs['err_id'];
?>
</td>
</tr>示例7: ResultDB
<table width="700" border="1" align="center" cellpadding="3" cellspacing="3">
<tr>
<td colspan="2" align="center" height="25"><font size="4"><b>б╥├и╤┤├╨┤╤║д╟╥┴├╪╣с├зв═з═╪║╤╡╘б╥├╖╤ш╟ф╗ (non - clinic)</b></font></td>
</tr>
<tr>
<td width="100" align="center"><b>д╟╥┴├╪╣с├з</b></td>
<td align="left"><b>р╦╡╪б╥├│ь</b></td>
</tr>
<tr>
<?php
$sqlS_general_relation = "SELECT * FROM risk_relation_general_program ";
$resultS_relation = ResultDB($sqlS_general_relation);
if (mysql_num_rows($resultS_relation) > 0) {
for ($i = 0; $i < mysql_num_rows($resultS_relation); $i++) {
$rsS_relation = mysql_fetch_array($resultS_relation);
print "<tr><td align='center'><b>" . $rsS_relation['name'] . "</b></td><td>" . $rsS_relation['description'] . "</td></tr>";
}
}
?>
</table>
<br/>
<center><input type="button" value="╗╘┤╦╣щ╥╡ш╥з╣╒щ" onclick="javascript:window.close()"></center>
示例8: thai_date
echo "<tr>";
echo "<td width='63' align='right'>" . ($i + 1) . ".</td>";
echo "<td width=380'>гя╧╥уХарця║ир╬бр╨ре " . thai_date(strtotime($rsOpd_Socail['arrear_date'])) . "</td>";
echo "<td width='150'>╗с╧г╧Ю╖т╧╥уХ╓Ир╖╙сцп</td>";
echo "<td align='right' width='55'>" . number_format(floor($rsOpd_Socail['amount'])) . "</td>";
echo "<td> ╨р╥</td>";
echo "</tr>";
echo "</table>";
$i++;
}
}
//while
?>
<?php
$sql_sum_price = "select sum(amount) as price from rcpt_arrear where hn='{$hn}' and paid ='N' group by hn";
$resultOpd_Socail_sum = ResultDB($sql_sum_price);
$resultOpd_Socail_sum = mysql_fetch_array($resultOpd_Socail_sum);
$price = $resultOpd_Socail_sum['price'];
?>
</td>
</tr>
<tr>
<td><font face="AngsanaUPC, BrowalliaUPC, CordiaUPC"> </font></td>
<td colspan="3"><font size="+2" face="AngsanaUPC, BrowalliaUPC, CordiaUPC"><strong>
цгаЮ╩Г╧Ю╖т╧╓Ир╖╙сцп╥яИ╖йтИ╧
<?php
echo number_format(floor($resultOpd_Socail_sum['price']));
?>
╨р╥ (<?php
echo num2wordsThai(floor($price));
?>示例9: ResultDB
<td colspan="2">
<?php
//sql create table show
$d1 = $sy1 . "-" . $sm1 . "-" . $sd1;
$d2 = $sy2 . "-" . $sm2 . "-" . $sd2;
//echo $d1."dd".$d2;
if ($refer_point != null) {
if ($refer_point == 'All') {
$sqlSocail_refer_opd = "\r\n\r\nSELECT ri.refer_point,ri.icd10,ic.name as icd_name,count(ri.icd10) AS total_group \r\n\r\nFROM referin ri\r\n\r\nLEFT OUTER JOIN icd101 ic on ic.code = ri.icd10\r\n\r\nWHERE \r\n\tri.refer_date BETWEEN '{$d1}' AND '{$d2}' \r\n\t\r\nGROUP BY ri.icd10 \r\n\r\nORDER BY ri.refer_point";
} else {
$sqlSocail_refer_opd = "\r\n\r\nSELECT ri.refer_point,ri.icd10,ic.name as icd_name,count(ri.icd10) AS total_group \r\n\r\nFROM referin ri\r\n\r\nLEFT OUTER JOIN icd101 ic on ic.code = ri.icd10\r\n\r\nWHERE \r\n\tri.refer_point='{$refer_point}' AND\r\n\tri.refer_date BETWEEN '{$d1}' AND '{$d2}'\r\n\t\t\r\nGROUP BY ri.icd10 \r\n\r\nORDER BY ri.refer_point";
}
}
$resultSocail_refer_opd = ResultDB($sqlSocail_refer_opd);
if (mysql_num_rows($resultSocail_refer_opd) > 0) {
print "<u><font color='green'><b>áÊ´§¢éÍÁÙŢͧÇѹ·Õè <font color='red'>{$sd1}</font> à´×͹ <font color='red'>" . change_month_isThai($sm1) . "</font> »Õ <font color='red'>" . ($sy1 + 543) . "</font> ¶Ö§Çѹ·Õè <font color='red'>{$sd2}</font> à´×͹ <font color='red'>" . change_month_isThai($sm2) . "</font> »Õ <font color='red'>" . ($sy2 + 543) . "</font>";
print "<br>ÁÕ·Ñé§ËÁ´ " . mysql_num_rows($resultSocail_refer_opd) . " ÃÒ¡ÒÃ</b></font></u>";
//create row
?>
<br><br>
<table width="700" border="1" cellspacing="0" cellpadding="0" class="bd-external">
<tr>
<td height="44" align="center">
<table width="700" border="0" cellpadding="1" cellspacing="1">
<tr class="headtable">
<td width="50" height="21" align="center" background="img_mian/bgcolor2.gif">·Õè</td>
<td width="100" align="center" background="img_mian/bgcolor2.gif">á¼¹¡</td>
<td width="100" align="center" background="img_mian/bgcolor2.gif">ICD10</td>示例10: count
?>
</td>
</tr>
<tr>
<td> </td>
<td align="left"> </td>
</tr>
</table></td>
</tr>
</table>
<p> </p>
</div></td>
<td width="148" align="center" valign="top" class="td-right">
<?php
$sqlPic = "select count(*) as cc from patient_image where hn='{$hn}' ";
$resultPic = ResultDB($sqlPic);
$rsPic = mysql_fetch_array($resultPic);
if ($rsPic["cc"] > 0) {
print "<center>HN : <font color='red' size='4'><b>{$hn}</b></font>";
echo "<a title=¤ÅÔê¡à¾×èÍ´ÙÃÙ»¢ÂÒ href=javascript:popup(\"get_patient_image.php?hn={$hn}\",260,340,0)><img src=\"get_patient_image.php?hn={$hn}\" width=\"120\" height=\"105\" vlign=\"middle\" border=\"1\"></a>";
print "<br><font color='#FFFFFF'>" . $rs['fullname'] . "</font></center>";
}
?>
</td>
</tr>
<tr valign="top">
<td height="16" background="img_mian/bgcolor2.gif" align="center"><font color=white>|
<a href="pttype_service.php">¤é¹ËÒãËÁè</a> | <a href="javascript:history.back(-1)">Âé͹¡ÅѺ</a> |</font>
</td>
<td height="16" background="img_mian/bgcolor2.gif"> </td>
</tr>示例11: change_month_isThai
} else {
print "<input name=\"s_mount\" type=\"text\" size=\"12\" value='" . change_month_isThai($s_month) . "' disabled>";
}
//name
$sqlName = "select * from opduser where loginname='{$s_name}' ";
$resultName = ResultDB($sqlName);
$rsName = mysql_fetch_array($resultName);
$code_log = $rsName['doctorcode'];
$name = $rsName['name'];
//bank
$result_Bank = ResultDB($sqlSelect_User_bank);
$rs_Bank = mysql_fetch_array($result_Bank);
$bank_no = $rs_Bank['bank'];
//old_detail ·Õè¼èÒ¹ÁÒ
$sqlDetail_Old = "select * from detail_account where UserID='{$s_name}' order by syear,mouth desc limit 1 ";
$resultDetail_Old = ResultDB($sqlDetail_Old);
$rsDetail_Old = mysql_fetch_array($resultDetail_Old);
?>
»Õ :
<input name="t_year" type="text" size="10" value="<?php
echo $s_year;
?>
" disabled>
ÃËÑÊ :
<input name="t_UserID" type="text" size="10" value="<?php
echo $code_log;
?>
" disabled>
ºÑªÕàÅ¢·Õè :
<input name="t_NoBank_Account" type="text" size="20" value="<?php 示例12: concat
<tr align="center">
<td colspan="2">
</td>
</tr>
<tr align="center">
<td colspan="2">
<?php
//sql create table show
$d1 = $sy1 . "-" . $sm1 . "-" . $sd1;
$d2 = $sy2 . "-" . $sm2 . "-" . $sd2;
//echo $d1."dd".$d2;
$sql_Socail = "select\r\nro.refer_hospcode, concat(hp.hosptype,' ',hp.name) as refer_hospname,\r\nrp.refer_response_type_name,rt.refer_type_name,ro.department,ro.vn,ro.refer_number,ro.hn,rfp.name as refer_point_name,ro.pre_diagnosis,d.name as doctor_name,ro.refer_number as refer_number,ks.department as department_name,ro.other_text,ro.refer_date,o.vstdate,ro.refer_time,o.vsttime,\r\n\r\nconcat(p.pname,p.fname,' ',p.lname) as ptname, concat(h.hosptype,' ',h.name) as hospname,pe.name as pttype_name,\r\n\r\n r.name as refername, ro.refer_point,ro.pre_diagnosis,ro.pdx as icd,ic.name as icd_name ,o.vstdate\r\n\r\n from referout ro\r\n\r\n\r\n left outer join ovst o on o.vn = ro.vn\r\n left outer join patient p on p.hn=ro.hn\r\n left outer join hospcode h on h.hospcode = ro.hospcode\r\n left outer join rfrcs r on r.rfrcs = ro.rfrcs\r\n left outer join refer_point_list rfp on rfp.name = ro.refer_point \r\n left outer join kskdepartment ks on ks.depcode = ro.depcode\r\n left outer join doctor d on d.code = ro.doctor\r\n left outer join pttype pe on pe.pttype = o.pttype\r\n left outer join icd101 ic on ic.code = ro.pdx\r\n left outer join refer_type rt on rt.refer_type = ro.refer_type\r\n left outer join refer_response_type rp on rp.refer_response_type_id = ro.refer_response_type_id\r\n\r\n\r\n left outer join hospcode hp on hp.hospcode = ro.refer_hospcode\r\n\r\n where ro.department = 'OPD' and ro.refer_date between '{$d1}' and '{$d2}' and ro.refer_type='{$refer_type}' and ro.depcode='{$department_type}'\r\n\r\n\r\n union \r\n \r\n select \r\n ro.refer_hospcode, concat(hp.hosptype,' ',hp.name) as refer_hospname,\r\n rp.refer_response_type_name,rt.refer_type_name,ro.department,ro.vn,ro.refer_number,ro.hn,rfp.name as refer_point_name,ro.pre_diagnosis,d.name as doctor_name,ro.refer_number as refer_number,ks.department as department_name,ro.other_text,ro.refer_date,o.regdate as vstdate,\r\n\r\n ro.refer_time,o.regtime as vsttime,concat(p.pname,p.fname,' ',p.lname) as ptname,\r\n concat(h.hosptype,' ',h.name) as hospname,pe.name as pttype_name, r.name as refername,\r\n ro.refer_point,ro.pre_diagnosis,ro.pdx as icd,ic.name as icd_name,o.regdate as vstdate\r\n\r\n from referout ro\r\n\r\n left outer join ipt o on o.an = ro.vn\r\n left outer join patient p on p.hn=ro.hn\r\n left outer join hospcode h on h.hospcode = ro.hospcode\r\n left outer join rfrcs r on r.rfrcs = ro.rfrcs\r\n left outer join refer_point_list rfp on rfp.name = ro.refer_point \r\n left outer join kskdepartment ks on ks.depcode = ro.depcode\r\n left outer join doctor d on d.code = ro.doctor\r\n left outer join pttype pe on pe.pttype = o.pttype\r\n left outer join icd101 ic on ic.code = ro.pdx\r\n left outer join refer_type rt on rt.refer_type = ro.refer_type\r\n left outer join refer_response_type rp on rp.refer_response_type_id = ro.refer_response_type_id\r\n\r\n left outer join hospcode hp on hp.hospcode = ro.refer_hospcode\r\n\r\n where ro.department = 'IPD' and ro.refer_date between '{$d1}' and '{$d2}' and ro.refer_type='{$refer_type}' and ro.depcode='{$department_type}' ";
$result_Socail = ResultDB($sql_Socail);
//echo mysql_num_rows($resultDenService);
if (mysql_num_rows($result_Socail) > 0) {
print "<u><font color='green'><b>áÊ´§¢éÍÁÙŢͧÇѹ·Õè <font color='red'>{$sd1}</font> à´×͹ <font color='red'>" . change_month_isThai($sm1) . "</font> »Õ <font color='red'>" . ($sy1 + 543) . "</font> ¶Ö§Çѹ·Õè <font color='red'>{$sd2}</font> à´×͹ <font color='red'>" . change_month_isThai($sm2) . "</font> »Õ <font color='red'>" . ($sy2 + 543) . "</font>";
print "<br>ÁÕ·Ñé§ËÁ´ " . mysql_num_rows($result_Socail) . " ÃÒ¡ÒÃ</b></font></u>";
//create row
?>
<br><br>
<table border="1" cellspacing="0" cellpadding="0" class="bd-external">
<tr>
<td height="44" align="center"><table width="900" border="0" cellpadding="1" cellspacing="1">
<tr class="headtable">
<td width="20" height="21" align="center" background="img_mian/bgcolor2.gif">No.</td>
示例13: elseif
print "<td align='center' bgcolor='red'> " . $rs['review_status'] . "</td>";
}
print "<td align='left'> " . $rs['review_staff'] . "</td>";
print "</tr>";
}
//for
} else {
//r sql1
print "<p ailgn='center'><font color='#319ACE'><b>áÊ´§ÃÒ¡ÒâͧÇѹ·Õè " . $date_current;
print "<h2>äÁèÁÕÃÒ¡ÒÃ</h2></font></p>";
}
//r sql1
} elseif ($select_date = "Continue") {
//click button
//echo "sql2".$sql2;
$result = ResultDB($sql2);
if (mysql_num_rows($result) > 0) {
//r sql1
print "<p align='center'><u><font color='#319ACE'><b>áÊ´§¢éÍÁÙŢͧÇѹ·Õè {$d_calen1['0']} à´×͹ " . change_month_isThai($d_calen1[1]) . " »Õ " . $d_calen1[2] . " ¶Ö§Çѹ·Õè {$d_calen2['0']} à´×͹ " . change_month_isThai($d_calen1[1]) . " »Õ " . $d_calen1[2];
print " ÁÕ·Ñé§ËÁ´ <font color='red'>" . mysql_num_rows($result) . "</font> ÃÒ¡ÒÃ</b></font></u></p>";
for ($i = 0; $i < mysql_num_rows($result); $i++) {
$rs = mysql_fetch_array($result);
if ($bg == '#FFFFFF') {
$bg = "#FFFFCC";
} else {
$bg = '#FFFFFF';
}
//$subject_send=$rs['subject'];
print "<tr bgcolor='{$bg}'>";
print "<td align='center'>" . ($i + 1) . "</td>";
print "<td align='center'> " . $rs['report_date_time'] . "</td>";示例14: while
<td width="119" align="center" background="img_mian/bgcolor2.gif">������</td>
<td width="49" align="center" background="img_mian/bgcolor2.gif">��ԹԤ</td>
<td width="110" align="center" background="img_mian/bgcolor2.gif">���ͤ�ԹԤ</td>
<td width="210" align="center" background="img_mian/bgcolor2.gif">����ѵԡ�õ�ǨBP</td>
</tr>
<?php
$i = 0;
while ($i < mysql_num_rows($resultOpd_Socail)) {
//while
$rsOpd_Socail = mysql_fetch_array($resultOpd_Socail);
$sqlOpd_Socail_details = "select count(o.hn) as hn_num\r\n\t\t\t\t\tfrom ovst o\r\n\r\n\t\t\t\t\tleft outer join clinicmember cl on cl.hn = o.hn\r\n\t\t\t\t\tleft outer join clinic c on c.clinic =cl.clinic\r\n\t\t\t\t\tleft outer join opdscreen oc on oc.vn = o.vn\r\n\t\t\t\t\tleft outer join patient pt on pt.hn = o.hn\r\n\t\t\t\t\twhere cl.clinic = '001' and (oc.bps!='' and oc.bpd!='') and (oc.bps<=130 and oc.bpd<=80) and o.hn='{$rsOpd_Socail['hn_number']}'\r\n\r\n\t\t\t\t\tand o.vstdate between '{$d1}' and '{$d2}'";
$w = 0;
$resultOpd_Socail_details = ResultDB($sqlOpd_Socail_details);
while ($w < mysql_num_rows($resultOpd_Socail_details)) {
$rsOpd_Socail_details = mysql_fetch_array($resultOpd_Socail_details);
if ($bg == "#FFFFFF") {
//color
$bg = "#B1C3D9";
//$bgm="";
} else {
$bg = "#FFFFFF";
//$bgm="img_mian/bgcolor.gif";
}
//color
?>
<tr bgcolor="<?php
echo $bg;
?>示例15: ResultDB
<table width="680" border="0" align="center" cellpadding="0" cellspacing="0" class="bdmain">
<tr bgcolor="#99CCFF">
<td height="24" colspan="2" align="center" background="img_mian/bgcolor2.gif" class="flist">
<b>Approve Command Doctor</b></td>
</tr>
<tr>
<td width="286" valign="top">
</td>
<td width="332"> </td>
</tr>
<tr>
<td> �س���
<?php
$Dcode = $_SESSION['Dcode'];
$sqlDcode = "select name from doctor where code='{$Dcode}' ";
$resultDcode = ResultDB($sqlDcode);
//$resultDcode=mysql_db_query($DBName,$sqlDcode)
//or die("�������ö���͡���������ʴ���".mysql_error());
$rsDcode = mysql_fetch_array($resultDcode);
echo $_SESSION['ip_Log'] . " <b><font color=red>>></b> " . $rsDcode["name"] . "</font><br>";
?>
</td>
<td align="right"> </td>
</tr>
<tr align="center" valign="bottom">
<td colspan="2">
<?php
//#---------------start
if (!$submit and $Send_Comment !== "Continue") {
//submit done button
$sqlList_commandDoc = "select *,MONTH(vstdate) as Month,MONTHNAME(vstdate) as month, (YEAR(vstdate)+543) as year,YEAR(vstdate) as Year,count(*) as total ";