query("insert into $tbl_area set city_id='$city_id',area='$area',pincode='$pincode',status=1 "); $_SESSION['sess_msg']='Area added successfully'; }else{ $sql=" update $tbl_area set city_id='$city_id',area='$area',pincode='$pincode' "; $sql.=" where id='".$_REQUEST['id']."'"; $obj->query($sql); $_SESSION['sess_msg']='Area updated successfully'; } header("location:area-list.php"); exit(); } if($_REQUEST['id']!=''){ $sql=$obj->query("select * from $tbl_area where id=".$_REQUEST['id']); $result=$obj->fetchNextObject($sql); } ?>

Admin: Add Area City: query("select * from $tbl_city where status=1 ",$debug=-1); while($resultCity=$obj->fetchNextObject($cityArr)){?> city_id==$resultCity->id){?>selected>city);?> Area: Pincode: