"; phpinfo(); echo "

"; // YOUR MSSQL 7.0 SERVER PARAMETERS $hostname = "192.168.1.1"; $conn = "mssqlconnection"; $username = "timesheetuser"; $password = "********"; echo "hostname = $hostname, conn = $conn, username = $username, password = $password

"; // YOUR MSSQL 7.0 DATABASE $dbname = "timesheet"; $tablename = "employeemaster"; // CONNECT TO THE MSSQL 7.0 DATABASE $connection = mssql_connect($hostname,$username,$password); // or die("database connection failed"); mssql_select_db("$dbname"); $sql_query = "select * from $tablename"; $query_result =mssql_query($sql_query); $number_rows = mssql_num_rows($query_result); $number_fields = mssql_num_fields($query_result); // TEST YOUR QUERY if($number_rows == 0) : print "The query does not produce any data row !"; elseif ($number_rows > 0) : print "Yes there are " . $number_rows . " rows resulting from the query."; endif; // DISPLAY TABLE FIELD HEADERS print ""; for ($field_number = 0 ; $field_number <= $number_fields - 1 ; $field_number++ ) { //$field_name = mssql_field_name($query_result, $field_number); print ""; } print ""; // DISPLAY INDIVIDUAL ROWS - POPULATING THE TABLE for ($row_number = 0 ; $row_number <= $number_rows - 1 ; $row_number++) { print ""; for ($field_number = 0 ; $field_number <= $number_fields - 1 ; $field_number++) { print ""; } print ""; } print "

row	" . $field_name . "
" . $row_number . "	" . mssql_result($query_result, $row_number, $field_number) . "

"; mssql_close($connection); ?>