Re: passing parameters

From: Date: Fri, 02 Feb 2001 10:44:03 +0000
Subject: Re: passing parameters
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-37808@lists.php.net to get a copy of this message
Rule #1: Do not post your database credentials into newsgroups. Rule #2: See Rule #1 "Stinie Steinbach" <s695645@kub.nl> a écrit dans le message news: 3A7A8A30.4000331B@kub.nl... > 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"; > } >

« previous php.general (#37808) next »