<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Web management</title>
<link rel="stylesheet" href="styles.css" type="text/css">
<?php include 'codes.php';?>
</head>
<body text="#000000" style="margin:0">
  <?php 
$id = mysql_real_escape_string(stripslashes($_REQUEST['id']));
$name = mysql_real_escape_string(stripslashes($_REQUEST['name']));
$email = mysql_real_escape_string(stripslashes($_REQUEST['email']));
$address = mysql_real_escape_string(stripslashes($_REQUEST['address']));
$city = mysql_real_escape_string(stripslashes($_REQUEST['city']));
$tel = mysql_real_escape_string(stripslashes($_REQUEST['tel']));
$comments = mysql_real_escape_string(stripslashes($_REQUEST['comments']));
 
if  (isset($_POST['submit'])) {
			$sql = "INSERT INTO nlmembers (category_id, name, email, address, city, tel, comments) VALUES ('$category_id', '$name', '$email', '$address', '$city', '$tel', '$comments')";
			$result = mysql_query($sql);
?>
<meta http-equiv="refresh" content="0;URL=new-nlmember.php">
<?php			
}
else  {
?>

<table width="980" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><div><img src="img/frame-add.png" width="180" height="37" alt=""></div>
<div class="frame">
<form name="forma" method="post" action="<?php echo htmlentities($_SERVER['PHP_SELF']); ?>" enctype="multipart/form-data">
  <table width="100%" border="0" cellspacing="0" cellpadding="4" class="text">
          <tr>
            <td width="20">&nbsp;</td> 
            <td width="200">Ομάδα 
            </td>
            <td><select name="category_id" class="forms">
              <?php
			$sql1 = "SELECT * FROM nlcategories ORDER BY id";
			$result1 = mysql_query($sql1);
			while ($myrow=mysql_fetch_array($result1)) {
				$category_id=$myrow['id'];
				$category=$myrow['category'];
?>
              <option value="<?php echo $category_id ?>"> <?php echo $category ?> </option>
              <?php } ?>
            </select></td>
          </tr>
          <tr>
            <td>&nbsp;</td> 
            <td>Ονομα</td>
            <td> 
              <input type="text" name="name" size="100" class="forms">
            </td>
          </tr>
          <tr>
            <td>&nbsp;</td> 
            <td>E-mail</td>
            <td> 
              <input type="text" name="email" size="100" class="forms">
            </td>
          </tr>
          <tr>
            <td>&nbsp;</td> 
            <td>Διεύθυνση</td>
            <td> 
              <input type="text" name="address" size="100" class="forms">
            </td>
          </tr>
          <tr>
            <td>&nbsp;</td> 
            <td>Πόλη</td>
            <td> 
              <input type="text" name="city" size="100" class="forms">
            </td>
          </tr>
          <tr>
            <td>&nbsp;</td> 
            <td>Tel</td>
            <td> 
              <input type="text" name="tel" size="100" class="forms">
            </td>
          </tr>
          <tr>
            <td>&nbsp;</td> 
            <td>Κείμενο</td>
            <td> 
              <textarea name="comments" cols="100" rows="6" class="forms"></textarea>
            </td>
          </tr>
        </table>

  <div align="center" style="padding:5px">
   <input type="submit" name="submit" value="Καταχώρηση" class="button">
        <input type="reset" name="reset" value="Επαναφορά" class="button">  </div>
</form>  
</div>
<div align="right"><a href="all-nlcategories.php" class="links">μεταφορά στην Λίστα</a></div></td>
  </tr>
</table><?php include 'menudown.php';?>
<?php } ?>
</body>
</html>