{
$sql1 = "select ee_id, f_name, l_name from $table_name order by l_name";
$result = mysql_query($sql1, $connection) or die(mysql_error());
while ($row1 = mysql_fetch_array($result)){
$ee_id1 = $row1['ee_id'];
$f_name = $row1['f_name'];
$l_name = $row1['l_name'];
$option_block .="<option value=\"$ee_id1\">$l_name, $f_name</option>";
}
$form_block1 = "
<html>
<body>
<center>
<table border = 1 cellpadding = 0 cellspacing = 1>
<tr><td>
<table border = 0 cellpadding = 0 cellspacing = 0>
<tr bgcolor = white><td colspan = 2><center><h1>Invoice Administration
<br>Login & Console</h1></center></td></tr>
<form method = post action=$php_self>
<center>
<tr bgcolor = white>
<td><strong>USERNAME:</strong></td>
<td><input type=text name=username size=25></td>
</tr>
<tr bgcolor=white>
<td valign = top><strong>PASSWORD:</strong></td>
<td><input type=text name=password size= 25><p></td>
</tr>
<tr bgcolor = lightblue>
<td valign = middle colspan = 2><strong><br>Select Emp Name:
</strong>
<select name=\"ee_id\">$option_block</select></td>
"; (I am just ending the form block - I like doing this to avoid all the
printfs and etc
View Cart
