<form name="search" action="" enctype="multipart/form-data">
<table width="100px" border="0" cellpadding="2" class="table" style="float:left;">
<tr align="center" valign="middle" bgcolor="#CCCCCC">
<td><strong>From Date</strong></td>
<td><input type="text" name="from_date1" id="from_date1" readonly="1" />
<script type="text/javascript">
function catcalc(cal) {
var date = cal.date;
var time = date.getTime()
// use the _other_ field
var field = document.getElementById("from_date1");
if (field == cal.params.inputField) {
field = document.getElementById("from_date1");
}
//field.value = date2.print("%d-%m-%Y");
}
Calendar.setup({
inputField : "from_date1", // id of the input field
ifFormat : "%Y-%m-%d", // format of the input field
showsTime : false,
timeFormat : "24",
onUpdate : catcalc
});
</script>
</td>
<td><strong>To Date</strong></td>
<td><input type="text" name="to_date1" id="to_date1" readonly="1" />
<script type="text/javascript">
function catcalc(cal) {
var date = cal.date;
var time = date.getTime()
// use the _other_ field
var field = document.getElementById("to_date1");
if (field == cal.params.inputField) {
field = document.getElementById("to_date1");
}
}
Calendar.setup({
inputField : "to_date1", // id of the input field
ifFormat : "%Y-%m-%d", // format of the input field
showsTime : false,
timeFormat : "24",
onUpdate : catcalc
});
</script>
</td>
<td><strong>Employee Type</strong></td>
<td>
<select name="emp_type_id1" id="emp_type_id1">
<option value="0">---Select---</option>
<option value="1">Executive</option>
<option value="2">Non-Executive</option>
</select>
</td>
<td><input name="Search" type="submit" value="Search"/></td>
</tr>
</table>
</form>
Here i want that user will search according to the three fields and clicking on search button will show the employee names .But the data has to retrieved from 3 tables, as my from-date and to_date is in another table and employee-type is in another table and employee-name is in another table, but in three tables emp_id is common.
And i want to show the data in the same page.