<h1>Projecten</h1>

<p><br /><a href="index.php?p=project_toevoegen" title="Project toevoegen">Project toevoegen</a></p>

<table cellpadding="20" cellspacing="0" border="0">
    <tr height="40">
        <th width="250"><span style="padding-left:10px;">Image</span></th>
        <th width="220">Naam</th>
        <th width="120">Op homepagina</th>
        <th width="150">Categorie</th>
        <th width="110">Wijzigen</th>
        <th width="110">Verwijderen</th>
    </tr>

<?php
	
	$q_nieuws = "SELECT kms_projecten.project_id, kms_projecten.naam, kms_projecten.populair, kms_projecten.categorie_id, kms_projecten.image_dir FROM kms_projecten ORDER BY kms_projecten.naam ASC";

	$r_nieuws = mysql_query($q_nieuws);
	
	$kleur = true;
	
	while($rec_nieuws = mysql_fetch_array($r_nieuws)){ ?>
        <tr height="120" <?php if($kleur) { echo("style=\"background-color:#eee\""); $kleur = false; }else{ $kleur = true; }?>>
        
            <td>
				<div class="thumb" style="width:240px; height:160px; margin-left:15px; margin-top:10px;"><img width="200" src="/projecten_images/<?php echo($rec_nieuws[4]); ?>/screen.jpg" alt="<?php echo(html_entity_decode($rec_nieuws[1])); ?>" /></div>
            </td>
            
            <td><?php echo(html_entity_decode($rec_nieuws[1])); ?></td>
            
            <td><?php if($rec_nieuws[2] == "yes"){ echo("ja"); }else{ echo("nee"); } ?></td>
            
            <td><?php 
					$q_categorie = sprintf("SELECT kms_categories.categorie_name FROM kms_categories WHERE kms_categories.categorie_id='%s'", $rec_nieuws[3]);
					$r_categorie = mysql_query($q_categorie);
					$rec_categorie = mysql_fetch_array($r_categorie);
					
					echo(html_entity_decode($rec_categorie['categorie_name']));
					?>
			</td>
                
            <td>
            
            <a href="index.php?p=project_wijzigen&amp;project_id=<?php echo($rec_nieuws[0]); ?>">Wijzigen</a>
            <br /><br />
            <a href="index.php?p=projectfoto_overzicht&amp;project_id=<?php echo($rec_nieuws[0]); ?>">Foto´s wijzigen</a>

            </td>
            <td><a href="index.php?p=project_verwijderen&amp;project_id=<?php echo($rec_nieuws[0]); ?>">Verwijderen</a>
            <br /><br /><br />
            </td>
        </tr>
<?php } ?>

</table>