Expand|Select|Wrap|Line Numbers
- <?php
- $sc=$_POST['sc'];
- $name=$_POST['name'];
- $emp=$_POST['ppa'];
- include("conn.php");
- $qry="select employer from corper";
- $rst=mysql_query($qry) or die(mysql_error());
- <select name="ppa" class="select">
- <option value=""></option>
- <?php while($row=mysql_fetch_assoc($rst)){
- echo "<option value='".$row['employer']."'>".$row['employer']."</option>";
- }
- if (isset($_POST['rvt']))
- {
- if(isset($_POST['sc']) && ($_POST['sc']!=''))
- {
- header("Location:http://www.nyscfct.org/detail.php?sc=$sc");
- }
- else if(isset($_POST['name']) && ($_POST['name']!='')){
- header("Location:http://www.nyscfct.org/searchresult.php?name=$name");
- }
- elseif(isset($_POST['ppa']) && ($_POST['ppa']!=''))
- {
- header("Location:searchresult.php?emp=$emp");
- }elseif(($_POST['sc']='') && ($_POST['name']='') && ($_POST['ppa']=''))
- {
- die('Please go back <a href="index.php">Home</a> fill in atleast one search criterea');
- }
- }
- ?>