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; ?>