/src/beheer/schade_edit.php

<?php
	$sqlSchade = "SELECT schademeldingen.*
					   , aanvragen.geslacht
					   , aanvragen.voorletters
					   , aanvragen.achternaam
					   , aanvragen.adres
					   , aanvragen.postcode
					   , aanvragen.woonplaats
					FROM schademeldingen 
					   , aanvragen
					WHERE aanvragen.aanvraag_id = schademeldingen.aanvraag_id
					  AND schademeldingen.id = '".$_GET["schade_id"]."'";


	$conn = mysql_connect('91.184.10.91', 'mysqlgratisgolf', 'g0lfp0l1s');
	mysql_select_db('gratisgolfpolis', $conn);

	$result = mysql_query("SELECT * FROM user WHERE id='".$_COOKIE["bid"]."'");
	$aantal = mysql_num_rows($result);

	if($aantal==1){
		$row = mysql_fetch_array($result);
		$bid = $row["id"];
		$bname = $row['name'];

	} else {
		header("Location:login.html");
	}
	
	$resultSchade = mysql_query( $sqlSchade );
	$rowSchade = mysql_fetch_array($resultSchade);
	$certnr = $rowSchade["aanvraag_id"] + 110000;
?>
<form action="index.php?act=updateschade&aanvraag_id=<?=$rowSchade["aanvraag_id"]?>" method="post">
	<input type="hidden" name="id" value="<?=$_GET['schade_id']?>"/>
    <table width="900" style="background-color:#eeeeee; color:#000000; font-family:Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal;">
        <tr height="30">
            <td colspan="3" align="center" style="background-color:#137601; color:#f0b300; font-family:Arial, Helvetica, sans-serif; font-size:14px; font-weight:bold;">gratisgolfpolis.nl | Schades</td>
        </tr> 

         <tr valign="top">
            <td width="150"><b>Cerificaat nr.</b></td>
            <td></td>
            <td><?=$certnr?></td>
        </tr>      
         <tr valign="top">
            <td width="150"><b>Aanhef</b></td>
            <td></td>
            <td><?=$rowSchade["geslacht"]?></td>
        </tr>    
         <tr valign="top">
            <td width="150"><b>Voorl.</b></td>
            <td></td>
            <td><?=$rowSchade["voorletters"]?></td>
        </tr>    
         <tr valign="top">
            <td width="150"><b>Naam</b></td>
            <td></td>
            <td><?=$rowSchade["achternaam"]?></td>
        </tr>    
         <tr valign="top">
            <td width="150"><b>Adres</b></td>
            <td></td>
            <td><?=$rowSchade["adres"]?></td>
        </tr>    
         <tr valign="top">
            <td width="150"><b>Postcode</b></td>
            <td></td>
            <td><?=$rowSchade["postcode"]?></td>
        </tr>    
         <tr valign="top">
            <td width="150"><b>Woonplaats</b></td>
            <td></td>
            <td><?=$rowSchade["woonplaats"]?></td>
        </tr>
        <tr><td colspan="3"><hr noshade size="2"/></td></tr>    
         <tr valign="top">
            <td width="150"><b>Schadedatum</b></td>
            <td></td>
            <td><input type="text" name="schadedatum" size="10" maxlength="10" value="<?=$rowSchade["schadedatum"]?>"/></td>
        </tr>
         <tr valign="top">
            <td width="150"><b>Schadeoorzaak</b></td>
            <td></td>
            <td><input type="text" name="oorzaak" size="85" value="<?=$rowSchade["oorzaak"]?>"/></td>
        </tr>
        <tr valign="top">
            <td width="150"><b>Schadesoort</b></td>
            <td></td>
            <td>
            	<select name="schadesoort">
                	<option value="1" <? if($rowSchade["schadesoort"]=="1") { ?>selected<?php }?> ?>>verlies clubs
                	<option value="2" <? if($rowSchade["schadesoort"]=="2") { ?>selected<?php }?>>diefstal clubs (op GC)
                	<option value="3" <? if($rowSchade["schadesoort"]=="3") { ?>selected<?php }?>>diefstal clubs (uit auto)
                	<option value="4" <? if($rowSchade["schadesoort"]=="4") { ?>selected<?php }?>>diefstal clubs (inbraak)
                	<option value="5" <? if($rowSchade["schadesoort"]=="5") { ?>selected<?php }?>>shaftbreuk clubs
                	<option value="6" <? if($rowSchade["schadesoort"]=="6") { ?>selected<?php }?>>diefstal kleding
                	<option value="7" <? if($rowSchade["schadesoort"]=="7") { ?>selected<?php }?>>hole-in-one
                	<option value="8" <? if($rowSchade["schadesoort"]=="8") { ?>selected<?php }?>>brand
                	<option value="9" <? if($rowSchade["schadesoort"]=="9") { ?>selected<?php }?>>overigen                  
                </select>
            </td>
        </tr>
         <tr valign="top">
            <td width="150"><b>Reserve EUR</b></td>
            <td></td>
            <td><input type="text" name="reserve" size="10" value="<?=$rowSchade["reserve"]?>"/></td>
        </tr>
         <tr valign="top">
            <td width="150"><b>Uitkering EUR</b></td>
            <td></td>
            <td><input type="text" name="uitkering" size="10" value="<?=$rowSchade["uitkering"]?>"/></td>
        </tr>
         <tr valign="top">
            <td width="150"><b>Notadatum</b></td>
            <td></td>
            <td><input type="text" name="notadatum" size="10" maxlength="10" value="<?=$rowSchade["notadatum"]?>"/></td>
        </tr>
         <tr valign="top">
            <td width="150"><b>Status</b></td>
            <td></td>
            <td>
            	<select name="status">
                	<option value="1" <? if($rowSchade["status"]=="1") {?>selected<?php } ?>>lopend
                	<option value="2" <? if($rowSchade["status"]=="2") {?>selected<?php } ?>>afgehandeld                 
                </select>
            </td>
        </tr>        

         <tr valign="top">
            <td width="150"><b>Opmerkingen</b></td>
            <td></td>
            <td><textarea name="opmerkingen" cols="50" rows="5"><?=$rowSchade["notadatum"]?></textarea></td>
        </tr>
    </table>
    <input type="submit" value="Opslaan" />
</form>