01.<?php
02.
03. $objConnect = mssql_connect("VIADTOP03\SQLEXPRESS2014","sa","5547") or die("Error Connect to Database");
04. $objDB = mssql_select_db("Physical_Count");
05.
06. $strSQL = "select * from Tbl_Actual_Check where RefNo2 = 'WP109456' ";
07.
08. $objQuery = mssql_query($strSQL) or die ("Error Query [".$strSQL."]");
09. $rows = mssql_num_rows($objQuery);
10.
11. if ($rows == 0)
12. {
13. echo "<center>Data not found.</center>";
14. }
15. else
16. {
17. for($i=0;$i<$rows;$i++)
18. {
19. echo mssql_result($objQuery,$i,"DateScan")."<br>";
20. }
21. }
22.?>
Load balance : Server 01
