Query Script

<?php

$categorie_query = 'SELECT id, naam FROM categorien ORDER BY id LIMIT 1';

$categorie_result = mysql_query($query) or die(mysql_error());

$categorie_naam = mysql_result($categorie_result,0,'naam');
$categorie_id = mysql_result($categorie_result,0,'id');

$films_query = 'SELECT * FROM films WHERE categorie = ' . $categorie_id;

//while enzo..

?>

<?php
 
$categorie_query = 'SELECT id, naam FROM categorien ORDER BY id LIMIT 1';
 
$categorie_result = mysql_query($query) or die(mysql_error());
 
$categorie_naam = mysql_result($categorie_result,0,'naam');
$categorie_id = mysql_result($categorie_result,0,'id');
 
$films_query = 'SELECT * FROM films WHERE categorie = ' . $categorie_id;
 
//while enzo..
 
?>