"; // YOUR MSSQL 7.0 SERVER PARAMETERS $hostname = "192.168.1.1"; $conn = "mssqlconnection"; $username = "timesheetuser"; $password = "********"; // YOUR MSSQL 7.0 DATABASE $dbname = "timesheet"; $tablename = "employeemaster"; // CONNECT TO THE MSSQL 7.0 DATABASE $connection = mssql_connect($hostname,$username,$password); mssql_select_db("$dbname"); $sql_query = "select emp_empname,emp_lname,emp_fname from employeemaster ORDER B Y emp_lname"; $query_result =mssql_query($sql_query); $number_rows = mssql_num_rows($query_result); $number_fields = mssql_num_fields($query_result); ?> " . $field_name->name . ""; } ?>