function html_query2selectbox($query, $domid)
{
// when you want to make a select box out of one or two columns from a table in the database
html_array2selectbox(executesql_returnKeyValPairs($query), $domid, true);
}
if ($SELECTEDUSER == 'Every One') {
$reportQuery = "select jid,task_day, task_mins, task_desc, task_user, FullName, projectName, Designation from VIEW_journals_human where task_day>='{$startDate}' and task_day <= '{$endDate}' order by task_user, jid DESC";
} else {
$reportQuery = "select jid,task_day, task_mins, task_desc, task_user, FullName, projectName, Designation from VIEW_journals_human where task_user='******' and task_day>='{$startDate}' and task_day <= '{$endDate}' order by task_user, jid DESC";
}
?>
<div style='clear:both;'></div>
<table align=center cellpadding=0 cellspacing=0 border=0 style='font-size: 95%;' width='95%'>
<tr>
<td colspan=6>
<FORM action='admin.php' method='POST'>
<div style='margin:10px;'>
View journal for
<?php
$listOfUsers = array_merge(array('Every One'), executesql_returnStrictArray("select username from users where role='enterjournals' "));
html_array2selectbox($listOfUsers, 'view_user');
?>
between <input type="text" size=12 id="startDate" name='startDate' class="date_input" value="">
and <input type="text" size=12 id="endDate" name='endDate' class="date_input" value="">
<INPUT TYPE='SUBMIT' value='Go'>
</div>
</FORM>
</td>
</tr>
<tr>
<td colspan=6>
<div style='margin:10px; width: 100%; text-align:center; margin-left:auto; margin-right:auto;'>
<B> Daily Journal for <?php
echo $SELECTEDUSER;
?>
