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";
}