Hy
below are my code. all is working ok but their are two fields "town" "UC" they are relevant to each other,every town have specific UC numbers, i just want when i select any town name (Iqbal, jinnah, layllpur, or madina) the UC filed automatically filtered with specific union numbers related to town.
the code is below
thanks in advance
[code<html>
<title>Complaint Cell</title>
<head>
<style type="text/css">
table{ width:50px }
body{width:80%;margin:auto;min-width:800px;max-width:2000px}
</style>
<link href="style.css" rel="stylesheet" type="text/css">
<img src="logo.jpg" width="100%">
</head>
<body bgcolor="#66FFCC" >
<div style="background: #096" align="center" id="inner" class="wrap"><font color="#FFFFFF" style="font-size:22px" ><h3 style='background:#096;margin:0px;'> Complaint Cell Management System </h3></div></font>
<div align="center" id="inner" class="wrap">
<?php
//conenction file
include "connection.php";
//cleaning string
function cleanString ($string)
{
$string=htmlspecialchars (trim($string));
return $string;
}
//function for new form
function print_Form() {
$newform = "<form method=\"post\"action=\"{$_SERVER['PHP_SELF']}\">
<table border=5 vspace='10' cellpadding=6 cellspacing=6 bgcolor='#CCCCCC' bordercolor='#009900' >
<tr ><td ><b>Date</b></td>
<td><input type=\"text\"name=\"Date\"></td>
<td><b>Complaint_Number</b></td>
<td><input type=\"number\"name=\"Complaint_Number\"></td></tr>
<tr><td><b>Name</b></td>
<td><input type=\"text\"name=\"Name\"></td>
<td><b> Address</b> </td>
<td><input type=\"text\"name=\"Address\"></td></tr>
<tr><td><b>CNIC</b></td>
<td ><input type=\"text\"name=\"CNIC\"></td>
<td><b> Town </b> </td>
<td >
<select name=\"town\" value='town'>
<option value='Iqbal'>Iqbal</option>
<option value='Jinnah'>Jinnah</option>
<option value='Layllpur'>Layllpur</option>
<option value='Madina'>Madina</option>
</select>
</td></tr>
<tr><td><b>UC</b></td>
<td><input type=\"text\"name=\"UC\">
<td><b> Category </b> </td>
<td >
<select name=\"Category\" value='Category'>
<option value='Sweeping Related'>Sweeping Related</option>
<option value='Open Heap'>Open Heap</option>
<option value='Waste in Open Plot'>Waste in Open Plot</option>
<option value='Container Over Flow'>Container Over Flow</option>
<option value='Other'>Other</option>
</select>
</td></tr>
<tr>
<td><b> Status </b> </td>
<td >
<select name=\"Status\" value='Status'>
<option value='In Process'>In Process</option>
<option value='Delay'>Delay</option>
<option value='Resolved'>Resolved</option>
<option value='ReAssign'>ReAssign</option>
</select>
</td>
<td><b>Mobile</b></td>
<td><input type=\"number\"name=\"Mobile\"></td>
</tr>
<tr><td><b>Remarks</b></td>
<td><input type=\"text\"name=\"Remarks\"></td></tr>
</table>
<input type=\"submit\"value=\"Add Record\">
<input type=\"hidden\"value=\"true\"name=\"post\">
</form>";
return $newform;
}
//search form
function searchForm($action) {
print "<form method='get' action='$action'>
<table border=5 vspace='10' cellpadding=6 cellspacing=6 bgcolor='#CCCCCC' bordercolor='#009900' ><tr><td>
Search by Mobile Number,CNIC or Name:</td><td>
<input type='text' name='search' maxlength='15'></td>
</tr>
</table>
<input type='submit' value='Search'>
</form>";
}
//saving record
function save_Record() {
$Date= cleanString ($_POST['Date']);
$Complaint_Number= (int) cleanString ($_POST['Complaint_Number']);
$Name = cleanString ($_POST['Name']);
$Address = cleanString ($_POST['Address']);
$CNIC = cleanString ($_POST ['CNIC']);
$Town = cleanString($_POST ['town']);
$UC = cleanString ($_POST ['UC']);
$Category = cleanString($_POST ['Category']);
$Status = cleanString ($_POST ['Status']);
$Mobile = cleanString ($_POST ['Mobile']);
$Remarks = cleanString ($_POST['Remarks']);
//checking for empty values
if(empty ($Name) || empty($Address) || empty ($CNIC) || empty($Town) || empty($UC) || empty($Mobile) || empty($Category) || empty($Status) || empty($Remarks ))
{
error_Message ("Cannot insert empty record");
}
//query
$query = "INSERT INTO main(Date,Complaint_Number,Name,Address,CNIC,Mobile,Town,UC,Category,Status,Remarks)
VALUES('$Date',$Complaint_Number,'$Name','$Address',$CNIC,$Mobile,'$Town','$UC','$Category','$Status','$Remarks')";
//execute query
if(mysql_query ($query)) {
print "<div style='background:#FFFFCC;border:dashed 1px #CCCCCC' id='inner' class='wrap'>
Record added successfully </div>";
print print_Form(); //show form again
}else{
error_Message (mysql_error()); //if error in query
}
}
//error message
function error_Message ($error) {
$msg = "<div style='background:#FFFFCC;border:dashed 1px #CCCCCC' id='inner' class='wrap'>;
$error <a href='javascript:history.go (-1) '>Back</a></div>";
die($msg);
}
//function for record listing
function show_Records_List() {
//page name for link, this will same the page, require for pagging
$page_name = $_SERVER ['PHP_SELF'];
//get start value for page
$start =$_GET['start'];
if (!isset($start)) {
$start=0;
}
//records per page
$limit = 5;
//next and previous operation
$back = $start - $limit;
$next = $start + $limit;
//retrive data from table
$main2 = mysql_query ("SELECT * FROM main") or
error_Message (mysql_error());
//get number of records in table
$nume = mysql_num_rows ($main2);
$main = mysql_query ("SELECT * FROM main ORDER BY Complaint_Number DESC LIMIT $start,$limit") or
error_Message (mysql_error());
// if no record exist
if (mysql_num_rows ($main) <=0) {
error_Message ("No record in result table");
}
//table header
print "<table border=5 cellpadding=1 cellspacing=1 bgcolor='#CCCCCC' bordercolor='#009900' >
<tr >
<th >Date</th>
<th>Complaint_Number</th>
<th>Name</th>
<th>CNIC</th>
<th>Mobile</th>
<th >Address</th>
<th>Town</th>
<th>UC</th>
<th>Category</th>
<th>Status</th>
<th>Remarks</th>
<th>Edit Record</th>
<th>Delete</th></tr>";
// loop through record set, create table and show results
while ($Row = mysql_fetch_array ($main)) {
print
"<tr >
<td>" .$Row['Date']."</td>
<td>" .$Row['Complaint_Number']."</td>
<td>" .$Row['Name'] . "</td>
<td>" .$Row['CNIC'] . "</td>
<td>" .$Row['Mobile']."</td>
<td >" .$Row['Address'] . "</td>
<td>" .$Row['Town']."</td>
<td>" .$Row['UC'] . "</td>
<td>" .$Row['Category']."</td>
<td>" .$Row['Status'] . "</td>
<td>" .$Row['Remarks'] . "</td>
<td ><a href='edit.php?do=edit&Complaint_Number=" .$Row['Complaint_Number']."'>Edit</a></td>
<td > <a href='edit.php?do=del&Complaint_Number=" .$Row['Complaint_Number']."'>Delete</a></td></tr>";
}
print "</table>";
print "<br><table border=5 cellpadding=1 cellspacing=1 bgcolor='#CCCCCC' bordercolor='#009900' ><tr>
<td style='background:#EAEAEA;margin:0px; >";
//previous link
if ($back >= 0) {
print "<a href='$page_name?start=$back'>Prev</a>";
}
$j = 1;
//printing page numbers as bar
for ($i = 0; $i < $nume; $i= $i + $limit) {
if ($i <> $start) {
print "<a href='$page_name?start=$i'>$j</a>";
}
else
{
//current page will not displayed as link
print "<span style='font:bold;'>$j</span>" ;
}
$j++;
}
if ($next < $nume) {
print "<a href='$page_name?start=$next' > Next </a>";
}
print "</td></tr></table>";
//end of function
}
/*
$Query = "Select * from main order by Complaint_Number desc";
//executing query
$q_main = mysql_query ($Query) or
error_Message (mysql_error());
if (mysql_num_rows ($q_main) <=0) {
error_Message ("No record found");
}
print "<table border=1 width='50%'> <tr>
<th>Complaint_Number</th>
<th>Name</th>
<th> CNIC </th>
<th> Mobile </th>
<th>Address</th>
<th>Remarks</th>
<th>Edit</th>
<th>Delete</th></tr>";
//getting records and generating table (rows,cols)
while ($Row=mysql_fetch_assoc ($q_main))
{ print "<tr>
<td>" .$Row['Complaint_Number']."</td>
<td>" .$Row['Name']."</td>
<td>" .$Row['CNIC']."</td>
<td>" .$Row['Mobile']."</td>
<td>" .$Row['Address']."</td>
<td>" .$Row['Remarks']."</td>
<td align='center'> <a href='edit.php?do=edit&Complaint_Number=" . $Row['Complaint_Number'] ."'>Edit</a></td>
<td align='center'>
<a href='edit.php?do=del&Complaint_Number=" .$Row['Complaint_Number']."'>Delete</a></td></tr>";
}
{print "</table>";
}
*/
//what to do
if(isset($_POST
['post']) ){
// if form is POSTED
save_Record();
}else{
//first time print the form
print print_Form();
}
//Result listing
print "<h3 style='background:#096;margin:0px;'>
Record Listing</h3>";
searchForm ('search.php');
show_Records_List();
?>
</div>
</body>
</html>][/code]