Untitled

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>International Marketing Group</title>
<link href="css/style.css" rel="stylesheet" type="text/css">
<link href="css/navigation.css" rel="stylesheet" type="text/css">
<link href="css/table.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="js/jquery-1.9.0.min.js"></script>
<script type="text/javascript" src="js/move-top.js"></script>

<script type="text/javascript">
        $(document).ready(function() {
            $().UItoTop({ easingType: 'easeOutQuart' });

        });
    </script>
    <a href="#" id="toTop"> </a>
    <script type="text/javascript" src="js/navigation.js"></script>
</head>

<body>
<div>
<img src="img/img.png" class="greatings" width="940" height="78">
</div>
    <div class="navigation">

                    <ul class="nav">
                        <li><a href="home.php">Home</a></li>
                        <li class="test"><a href="#">Membership Form</a>
                            <ul>
                                <li><a href="form.php">Add Member</a></li>
                                <li><a href="edit.php">Edit Member</a></li>
                                <li><a href="viewalldelete.php">Delete Member</a></li>
                                <li><a href="#">Update Member</a></li>
                            </ul>
                        </li>

                        <li><a href="viewall.php">Show All Members</a></li>
                        <li><a href="#">Contact Us</a></li>
                        <li><a class="logout" href="logout.php">Logout</a></li>
                    </ul>
                             <span class="left-ribbon"> </span>
                             <span class="right-ribbon"> </span>
    </div>

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("form", $con);
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("form", $con);
//$sql="select * from accountdtl";
$result = mysql_query("select * from personal_tbl where no='$_POST[name]'");
while($rowval = mysql_fetch_array($result))
 {
     function viewData()
{
// PERSONAL INFORMATION
    $no=$rowval['no'];
    $lname=$rowval['lname'];
    $fname=$rowval['fname'];
    $mname=$rowval['mname'];
    $nname=$rowval['nname'];
    $gender=$rowval['gender'];
    $cstatus=$rowval['cstatus'];
    $nospouse=$rowval['nospouse'];
    $dobirth=$rowval['dobirth'];
    $citizenship=$rowval['citizenship'];
    $residencens=$rowval['residencens'];
    $barangay=$rowval['barangay'];
    $city=$rowval['city'];
    $province=$rowval['province'];
    $zipcode=$rowval['zipcode'];
    $country=$rowval['country'];
    $residence=$rowval['residence'];
    $telnumber=$rowval['telnumber'];
    $mobnumber=$rowval['mobnumber'];
    $email=$rowval['email'];
    // END OF PERSONAL INFORMATION
}
mysql_close($con);
 }
?>

<h2 class="add"><-------------------- Search Result --------------------></h2>
    <div id="form">
    <img class="logo" src="img/img-logo.jpg" width="250px" height="100">
        <p id="toptext">APPLICATION FOR MEMBERSHIP WITH IMG</p>

           <form method="post">
                <div class="idnum">
                    <label class="id">No.</label>
                    <input class="id1" type="text" name="no" placeholder="ID Number Here" value='<?php echo  $no; ?>'  required>
                </div>

                <!--######################################################################################################################################-->


                    <p class="midtext">PLEASE PRINT ALL ANSWERS</p>

                        <fieldset id="personalbox">
                        <legend class="personal"><b>PERSONAL INFORMATION</b></legend>
                        <!--##-->
                        <div class="lnfn">
                        <label>LASTNAME</label> &nbsp; <label class="fnspace">FIRSTNAME</label>
                        </div>
                        <input class="lastname" type="text" name="lname" placeholder="Lastname" required> &nbsp; <input class="firstname" type="text" name="fname" placeholder="Firstname" required><br>

                        <!--##-->
                        <div class="mnnng">
                         <label>MIDDLENAME</label> &nbsp; <label class="nnspace">NICKNAME</label> &nbsp; <label class="gspace">GENDER</label><br>
                         <input class="middlename" type="text" name="mname" placeholder="Middlename" required> &nbsp; <input class="nickname" type="text" name="nname" placeholder="Nickname"required> &nbsp;
                         <input class="gender" type="radio" name="gender"
                         <?php if (isset($gender) && $gender=="female") echo "checked";?>  value="female"> &nbsp;Female &nbsp; &nbsp;
                         <input type="radio" name="gender"
                         <?php if (isset($gender) && $gender=="male") echo "checked";?>  value="male">&nbsp;Male<br>
                        </div>

                        <!--##-->
                        <div class="csnsdbc">
                         <label>CIVIL STATUS</label> &nbsp; <label class="nsspace">NAME OF SPOUSE</label> &nbsp; <label class="dbspace">DATE OF BIRTH</label> &nbsp; <label class="ctspace">CITIZENSHIP</label><br>
                         <select class="civilstatus" name="cstatus"><!--##PICKER-->
                         <option value =""></option>
                         <option value ="Single">Single</option>
                         <option value="Married">Married</option>
                         <option value ="Divorced or Separated">Divorced or Separated</option>
                         <option value ="Widowed">Widowed</option>
                         </select> &nbsp;<!--##END OF PICKER-->
                         <input class="nameofspouse" type="text" name="nospouse" placeholder="Name of spouse" required> &nbsp; <input class="dateofbirth" type="date" name="dobirth" placeholder="Date of Birth" required> &nbsp; <input class="citizenship" type="text" name="citizenship" placeholder="Citizenship" required><br>
                        </div>

                         <!--##-->
                         <div class="rnas">
                         <label>RESIDENCE NUMBER AND STREET</label><br>
                         <input class="residencenas" type="text" name="residencens" placeholder="Residence Number and Street" required> <br>
                        </div>

                         <!--##-->
                         <div class="b">
                         <label>BARANGAY</label><br>
                         <input class="barangay" type="text" name="barangay" placeholder="Barangay" required> <br>
                        </div>

                         <!--##-->
                        <div class="cp">
                        <label>CITY</label> &nbsp; <label class="pspace">PROVINCE</label>
                        </div>
                        <input class="city" type="text" name="city" placeholder="City" required> &nbsp; <input class="province" type="text" name="province" placeholder="Province" required ><br>

                          <!--##-->
                        <div class="zc">
                        <label>ZIPCODE</label> &nbsp; <label class="cspace">COUNTRY</label>
                        </div>
                        <input class="zipcode" type="text" name="zipcode" placeholder="Zipcode" required> &nbsp;
                        <select class="country" name="country"><!--##PICKER-->
                        <option><?php include "country.php"; ?></option>
                        </select><br><!--##END OF PICKER-->

                         <!--##-->
                        <div class="rtme">
                        <label>RESIDENCE</label> &nbsp; <label class="tnspace">TEL-NUMBER</label> &nbsp; <label class="mnspace">MOBILE-NUMBER</label> &nbsp; <label class="easpace">EMAIL-ADDRESS</label>
                        </div>
                        <input class="residence" type="text" name="residence" placeholder="" required> &nbsp; <input class="telnumber" type="text" name="telnumber" placeholder="" required> &nbsp; <input class="mobnumber" type="text" name="mobnumber" placeholder="" required> &nbsp; <input class="email-add" type="email" name="email" placeholder="Email-Address" required><br>

                        </fieldset>
                <br>
</div>
</body>
</html>