Rule #1:
Do not post your database credentials into newsgroups.
Rule #2:
See Rule #1
"Stinie Steinbach" <[EMAIL PROTECTED]> a écrit dans le message news:
[EMAIL PROTECTED]
> 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.da
tum,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";
> }
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
