does anyone know what's wrong with this files?
i want to pass the parameter $module_id from one file tot the next so
that i can extract all records from my tables in the mysql database that
have this parameter... the queries that i used are tested and are
working correctly... at this moment i cant see waht i do wrong.. does
anyone know an answer tot my problem? if you need tot know more about
the result look at my url.. please help me....

http://stuwww.kub.nl/~s695645/TIAS/

file test_blok_array.php3

<? include("connect.php3") ?>

<?
$result = mysql_query ("select m.module_id,m.module_nummer
   from module m, leergang l where m.leergang_afkorting =
l.leergang_afkorting
   and m.leergang_afkorting = 'EDP16' order by m.module_nummer");
while (list ($module_id,$module_nummer) = mysql_fetch_row ($result)) {

 echo "<a href=\"test_list.php3?module_id=$module_id\"> BLOK
0$module_nummer | </a>";
}
?>

file test_list.php3

<? include("test_blok_array.php3") ?>

<table>
<form action="_url_" method="post">

 <table border=1>
 <tr>
  <th>submodule</th>
  <th>onderdeel</th>
  <th>docent</td>
  <th>datum</th>
  <th>dagdeel</th>
  <th>edit</th>
  <th>delete</th>
 </tr>

<?php
mysql_connect ("kubstu.kub.nl","s695645","BikHuis");
mysql_select_db ("s695645");
$result = mysql_query ("SELECT
u.module_id,u.submodule_nummer,u.submodule_naam,d.docent_naam,s.dagdeel,s.datum,u.submodule_id,u.submodule_id

   FROM submodule u, sessie s, docent d, module m
   WHERE u.module_id = '$module_id'
   AND d.docent_nummer = s.docent_nummer
   AND u.submodule_id = s.submodule_id
   AND m.module_id = u.module_id
   AND m.leergang_afkorting = 'EDP16'
   ORDER BY s.datum, u.submodule_nummer");
while (list ($module_id, $submodule_nummer, $submodule_naam,
$docent_naam, $dagdeel, $datum, $submodule_id, $submodule_id) =
mysql_fetch_row ($result)) {
    echo   " <tr>
             <td><small>$submodule_nummer</small></td>
             <td><small>$submodule_naam</small></td>
             <td><small>$docent_naam</small></td>
             <td><small>$datum</small></td>
             <td><small>$dagdeel</small></td>
      <td><a href=\"edit.php3?submodule_id=$submodule_id\"><small> edit
</small></a></td>
             <td><a
href=\"delete.php3?submodule_id=$submodule_id\"><small> delete
</small></a></td>
             </tr>\n";
}

Reply via email to