<?php
echo $_GET['id'];
?>
<?php
$start = $_GET['date'];
$end = $_GET['date1'];
$sec = $_GET['sec'];
?>
<html>
<head><title>Untitled Document</title>
</head>
<body>
<?php
$connect = mysql_connect("localhost", "root", "") or
die ("check your server connection.");
mysql_select_db("jobs");
$quey1="select * from job WHERE sec='$sec' AND date BETWEEN '$start' AND '$end' AND base='S L N S Rangala'ORDER BY date";
;
$result=mysql_query($quey1) or die(mysql_error());
?>
<table border=1 style="background-color:#FFFF;" >
<tr>
<th>Date</th>
<th>Base</th>
<th>Section</th>
<th>Received Job No</th>
<th>Job Reg No</th>
<th>Equipment</th>
<th>Deffect</th>
<th>Status</th>
<th>Refference</th>
</tr>
<?php
while($row=mysql_fetch_array($result)){
//print_r($row);
?>
<tr>
<td><?php echo $row['date']; ?></td>
<td><?php echo $row['base']; ?></td>
<td><?php echo $row['sec']; ?></td>
<td><?php echo $row['rejno']; ?></td>
<td><?php echo $row['jreno']; ?></td>
<td><?php echo $row['equ']; ?></td>
<td><?php echo $row['deff']; ?></td>
<td><?php echo $row['sta']; ?></td>
<td><?php echo $row['ee']; ?></td>
</tr>
<?php
}
?>
</table>
</body>
</html>
<html>
<head>
<title>Untitled Document</title>
</head>
<body>
<form action="rangala.php" method="get">
<table>
<tr>
<td>Section </td>
<td>
<select name="sec">
<option> </option>
<option>R/W/S/(A/V)</option>
<option>R/W/S/(Radio)</option>
</select>
</td>
</tr>
<tr>
<td> </td>
<td><input type="submit" value="View Prograss" /><input type="reset" value="Cancel" /></td>
</tr>
</table>
</form>
</body>
</html>
No comments:
Post a Comment