format("Y-m-d"); if(isset($_POST['done'])){ $SearchEmployees = mysql_escape_string($_POST['SearchEmployees']); $addCompID = mysql_escape_string($_POST['addCompID']); $lookUp = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `u_lname` LIKE '%$SearchEmployees%' AND `company`='$addCompID' || `u_fname` LIKE '%$SearchEmployees%' AND `company`='$addCompID'"); echo "
REC.ID. | "; echo "LAST NAME | "; echo "FIRST NAME | "; echo "POSITION | "; echo ""; while($row=mysql_fetch_array($lookUp)){ $count = $count + 1; ?>
---|---|---|
".strtoupper($row['u_lname'])." | "; echo "".strtoupper($row['u_fname'])." | "; echo "".strtoupper($row['u_position'])." | "; echo "