<h1>Subcategorie&euml;n</h1>

<p><br /><a href="index.php?p=subcategorie_toevoegen" title="Subcategorie toevoegen">Subcategorie toevoegen</a></p>

<table cellpadding="20" cellspacing="0" border="0">
    <tr height="30">
	    <th width="40"></th>
        <th width="300">Subcategorie naam</th>
        <th width="300">Categorie naam</th>
        <th width="110">Wijzigen</th>
        <th width="110">Verwijderen</th>
    </tr>

<?php

	$q_cases = "SELECT kms_subcategories.subcategorie_id, kms_subcategories.categorie_id, kms_subcategories.subcategorie_name FROM kms_subcategories ORDER BY subcategorie_name ASC";
	$r_cases = mysql_query($q_cases);
	
	$kleur = true;
	
	while($rec_cases = mysql_fetch_array($r_cases)){ ?>
        <tr height="30" <?php if($kleur) { echo("style=\"background-color:#eee\""); $kleur = false; }else{ $kleur = true; }?>>
        	<td>&nbsp;</td>
            <td><?php echo(html_entity_decode($rec_cases[2])); ?></td>
            <td>
				<?php 
					$q_categorie = sprintf("SELECT kms_categories.categorie_name FROM kms_categories WHERE categorie_id='%s'", $rec_cases[1]);
					$r_categorie = mysql_query($q_categorie);
					$rec_categorie = mysql_fetch_array($r_categorie);
					
					$naam = $rec_categorie['categorie_name'];
					
					echo(html_entity_decode($naam)); 
				?>       
            </td>
            <td><a href="index.php?p=subcategorie_wijzigen&amp;subcategorie_id=<?php echo($rec_cases[0]); ?>">Wijzigen</a></td>
            <td><a href="index.php?p=subcategorie_verwijderen&amp;subcategorie_id=<?php echo($rec_cases[0]); ?>">Verwijderen</a></td>
        </tr>
<?php } ?>

</table>