
|
// YOUR MSSQL 7.0 DATABASE
$dbname = "timesheet";
// YOUR MSSQL 7.0 SERVER PARAMETERS
$hostname = "192.168.1.1";
$username = "timesheetuser";
$password = "********";
// CONNECT TO THE MSSQL 7.0 DATABASE
$connection = mssql_connect($hostname,$username,$password);
mssql_select_db("$dbname");
$sql_query = "SELECT emp_lname,emp_fname,emp_email FROM employeemaster WHERE emp_enddate is null ORDER BY emp_lname";
$query_result =mssql_query($sql_query);
$number_rows = mssql_num_rows($query_result);
$number_fields = mssql_num_fields($query_result);
?>
| Last Name |
First Name |
Email Address |
while ($row = mssql_fetch_array($query_result))
{
?>
| = $row["emp_lname"] ?> |
= $row["emp_fname"] ?> |
">= $row["emp_email"] ?>
|
}
mssql_close($connection);
?>
|