edit / delete

<? 
//connect to mysql
mysql_connect("localhost","login","password"); 
	
//select which database you want to edit
mysql_select_db("mijn_DB"); 

//If cmd has not been initialized
if(!isset($cmd)) 
{
   //display all 
   $result = mysql_query("select * from locaties order by id"); 
   
   //run the while loop 
   while($row=mysql_fetch_array($result)) 
   { 
      //grab the names
	$id = $row["id"];
   $lat = $row["lat"];
   $lon = $row["lon"];
   $naam = $row["naam"];
   $adres = $row["adres"];
   $postcode = $row["postcode"];
   $plaats = $row["plaats"];
   $url = $row["url"];
   $icon = $row["icon"];
   $tel = $row["tel"];

	 //make edit / delete links
      echo "$id $naam <a href='edit.php?cmd=edit&id=$id'> Edit</a> / <a href='edit.php?cmd=delete&id=$id'> Delete</a>";
      echo "<br>";
    }
}
?>

<?

//edit option

if($_GET["cmd"]=="edit" || $_POST["cmd"]=="edit")
{
   if (!isset($_POST["submit"]))
   {
      $id = $_GET["id"];
      $sql = "SELECT * FROM locaties WHERE id=$id";
      $result = mysql_query($sql);        
      $myrow = mysql_fetch_array($result);
      ?>
      
      
<?  

//delete option

if($_GET["cmd"]=="delete")
{
   
    $sql = "DELETE FROM locaties WHERE id=$id";
    $result = mysql_query($sql);
	
    echo "Row deleted!";
}
?>	  


      <form action="edit.php" method="post">
      <input type=hidden name="id" value="<?php echo $myrow["id"] ?>">
   
<TABLE>
<TR>
   <TD>Locatienaam:</TD>
   <TD><INPUT TYPE='TEXT' NAME='naam' VALUE='<?php echo $myrow["naam"] ?>' size=60></TD>
</TR>
<TR>
  <TD>Adres:</TD>
  <TD><input type='TEXT' name='adres' value='<?php echo $myrow["adres"] ?>' size=60></TD>
</TR>
<TR>
  <TD>Postcode</TD>
  <TD><input type='TEXT' name='postcode' value='<?php echo $myrow["postcode"] ?>' size=60></TD>
</TR>
<TR>
   <TD>Plaats</TD>
   <TD><input type='TEXT' name='plaats' value='<?php echo $myrow["plaats"] ?>' size=60></TD>
</TR><br>
<TR>
  <TD>Website</TD>
  <TD><input type='TEXT' name='url' value='<?php echo $myrow["url"] ?>' size=60></TD>
</TR>
<TR>
  <TD>Telefoon</TD>
  <TD><input type='TEXT' name='tel' value='<?php echo $myrow["tel"] ?>' size=60></TD>
</TR>
<TR>
   <TD>Soortlocatie</TD>
   <TD>
      <SELECT NAME='icon'>
         <OPTION VALUE='gray'>winkel
         <OPTION VALUE='green'>autoclub
         <OPTION VALUE='red'>vliegclub
         <OPTION VALUE='blue'>botenclub
      </SELECT>
   </TD>
</TR>
<TR>
   <TD>Lat</TD>
   <TD>
      <INPUT TYPE='TEXT' NAME='lat' VALUE='<?php echo $myrow["lat"] ?>' size=60>
   </TD>
</TR>
<TR>
   <TD>Lon</TD>
   <TD>
      <INPUT TYPE='TEXT' NAME='lon' VALUE='<?php echo $myrow["lon"] ?>' size=60>
   </TD>
</TR>
<TR>
   <TD></TD><br>
   <TD><INPUT TYPE="submit" name="submit" value="submit"></TD> 
</TR>
</TABLE>
   
      <input type="hidden" name="cmd" value="edit">
   
      </form>

   
<? } ?>
<?
   if ($_POST["$submit"])
   {
     
   $lat = $_POST['lat'];
   $lon = $_POST['lon'];
   $naam = $_POST['naam'];
   $adres = $_POST['adres'];
   $postcode = $_POST['postcode'];
   $plaats = $_POST['plaats'];
   $url = $_POST['url'];
   $icon = $_POST['icon'];
   $tel = $_POST['tel'];
	  
	  $sql = "UPDATE locaties SET naam='$naam',adres='$adres',postcode='$postcode',plaats='$plaats',url='$url',icon='$con',tel='$tel',lat='$lat',lon='$lon' WHERE id=$id";
      
      $result = mysql_query($sql);
	  
      echo "Thank you! Information updated.";
	}
}
?>