Archief - MySQL: 2 query's mengen

<?PHP 
 require("header1.php");
?>
<?PHP
 include("connect.php");
 include("text.php");
 $i = "0";
 $query1 = mysql_query("SELECT id,naam,beschrijving,onderwerpen,berichten,categorie FROM forum") OR die("mysql foutje op lijn ". __LINE__);
 $query2 = mysql_query("SELECT id,naam,afkorting FROM categorie") OR die("mysql foutje op lijn ".__LINE__);
 $query3 = mysql_query("SELECT id,naam,afkorting FROM categorie LIMIT $i,1")OR die("mysql foutje op lijn ".__LINE__);
 $query4 = mysql_query("SELECT id,naam,beschrijving,onderwerpen,berichten,categorie FROM forum WHERE categorie = $i");
 
 $resultaat3 = mysql_fetch_array($query3);
 $resultaat4 = mysql_fetch_array($query4);

 echo "index.php";
 echo "<table border=\"0\">";

 while( $resultaat2 = mysql_fetch_array($query2) )
 { 
  echo "<tr>";
  echo "<td colspan=\"3\" class=\"categorie\">";
  echo $resultaat3[naam];
  echo "</td>";
  echo "</tr>";
	while( $resultaat1 = mysql_fetch_array($query1) )
	{
	echo "<tr>";
	echo "<td class=\"forum\">";
	echo "<a href=\"vieuwforum.php?for=";
	echo $resultaat4[id];
	echo "\">";
	echo $resultaat4[naam];
	echo "</a>";
	echo "<br \>";
	echo $resultaat4[beschrijving];
	echo "</td>";
	echo "<td class=\"forum\">";
	echo $resultaat4[onderwerpen];
	echo "</td>";
	echo "<td class=\"forum\">";
	echo $resultaat4[berichten];
	echo "</td>";
	echo "</tr>";
	}
  $i++;
 }
?>
<?PHP
 include("footer1.php");
?>

+------------------------------------+
|        table member                         |
+------------------------------------+
| id(tinyint(5) auto-increment,unique   |
| naam (varchar(100))                      |
| functie    (tinyint(2))                      |
+------------------------------------+

+-------------------------------------+
|          table benamingen                   |
+-------------------------------------+
| id (tinyint(2) auto-increment, unique   |
| benaming (varchar(10))                    |
+-------------------------------------+