echo "Hello World!
";
// 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);
?>
for ($field_number = 0 ; $field_number <= $number_fields - 1 ; $field_number++ )
{
$field_name = mssql_fetch_field($query_result);
print "" . $field_name->name . " | ";
}
?>
while ($row = mssql_fetch_array($query_result))
{
?>
= $row["emp_empname"] ?> | = $row["emp_lname"] ?> |
= $row["emp_fname"] ?> |
}
mssql_close($connection);
?>