gladz0r
-
Posts
3 -
Joined
-
Last visited
Never
gladz0r's Achievements
Newbie (1/5)
0
Reputation
-
I've got the following script online: http://sbshasselt.be/ictco/maarten/icttips/index.php It's in dutch but I'll explain the system, depending on the choice you make you'll get an result: 1. Show everything 2. Choose "Vak" - klas and eindterm stays <-- .. --> .. This is the code u used (2. Choose "Vak" - klas and eindterm stays <-- .. -->): if($leerjaar == '<-- Kies klas -->' && $eindterm == '<-- Kies eindterm -->' && $vak != '<-- Kies vak -->') { ?> <div align="center" class="style1"><b>Activiteiten voor <? echo $vak ?></b></div> <table width="100%" border="1"> <tr> <td width="50px" class="style7"><b><p class="style3">Oefening</p></b></td> <td width="50px" class="style7"><b><p class="style3">Leerjaar</p></b></td> <td width="50px" class="style7"><b><p class="style3">Vak</p></b></td> <td width="50px" class="style7"><b><p class="style3">Lesonderwerp</p></b></td> <td width="50px" class="style7"><b><p class="style3">Doelstelling</p></b></td> <td width="20px" class="style7"><b><p class="style3">Media</p></b></td> <td width="50px" class="style7"><b><p class="style3">Eindterm</p></b></td> </tr> <?php $sql = "SELECT * FROM `formulier` WHERE (`vak` = '$vak') ORDER BY leerjaar ASC"; $qSelect_berichten = $db->simpleQuery($sql) or die (mysql_error()); while($db->fetchInto($qSelect_berichten, $aBerichten, DB_FETCHMODE_ASSOC)) { echo '<tr> <td width="50"><p class="style4">'.$aBerichten['id'].'</p></td> <td width="50"><p class="style4">'.$aBerichten['leerjaar'].'</p></td> <td width="50px"><p class="style4"><img src="vakken/'.$aBerichten['vak'].'.jpg" width="60" height="60" /></p></td> <td width="50px"><p class="style4">'.$aBerichten['lesonderwerp'].'</p></td> <td width="50px"><p class="style4">'.$aBerichten['doelstelling'].'</p></td> <td width="20px"><p class="style4"><a href="'.$aBerichten['ict2'].'" target="_blank"><img src="url.png" width="48" height="48" /></a></p></td> <td width="30%"><p class="style4">'.$aBerichten['eindterm'].'</p></td> </tr>'; } echo '</table>'; } Now I want to add the following code to my script, WHEN $aBerichten['ict2'] equals "http://" <td width="20px"><p class="style4"><a href="'.$aBerichten['ict2'].'" target="_blank"><img src="url.png" width="48" height="48" /></a></p></td> the site shoulld give no image in the column "MEDIA". http://sbshasselt.be/ictco/maarten/icttips/index.php . Where and How shoulld i adjust this?
-
I can't get my function in the right way, sorry i'm a beginner can you help me? $sql = "SELECT * FROM `formulier` WHERE (`leerjaar` LIKE '$_POST["leerjaar"]' AND `vak` LIKE '$_POST["name"]')"; Doesn't work
-
Hello there I've made a script that shows database entries filtered by a searchbox. The problem is that the 2 HTTP_POST_VARS don't cooperate. For example when you choose 'Leerjaar' -> '1ste leerjaar' and 'Vak' -> 'Wiskunde' it has to show the entries of '1ste leerjaar' that have 'Vak' = Wiskunde. See the website at http://sbshasselt.be/ictco/maarten/htdocs/ Script Searchbox echo "<HTML>\n <HEAD><TITLE>Filter</TITLE></HEAD> <BODY> <p> <FORM METHOD=\"POST\" ACTION=\"index.php\"> <b>Filter op leerjaar:</b><br> <select name=\"leerjaar\" id=\"leerjaar\"> <option> </option> <option>1ste kleuter</option> <option>2de kleuter</option> <option>3de kleuter</option> <option>1ste lager</option> <option>2de lager</option> <option>3de lager</option> <option>4de lager</option> <option>5de lager</option> <option>6de lager</option> </select> <b>Vak</b><br> <select name=\"vak\" id=\"vak\"> <option> </option> <option>Taal</option> <option>Wiskunde</option> </select> <input type=\"submit\" name=\"submit\" value=\"Zoeken\"> </p> </BODY> </HTML>"; Page <?php include("zoek2.php"); ?> <table width="100%" border="1"> <tr> <td width="50px" class="style7"><b><p class="style3">Leerjaar</p></b></td> <td width="50px" class="style7"><b><p class="style3">Vak</p></b></td> <td width="50px" class="style7"><b><p class="style3">Lesonderwerp</p></b></td> <td width="50px" class="style7"><b><p class="style3">Doelstelling</p></b></td> <td width="20px" class="style7"><b><p class="style3">IN</p></b></td> <td width="50px" class="style7"><b><p class="style3">Media</p></b></td> </tr> <?php $sql = "SELECT * FROM `formulier` WHERE (`leerjaar` LIKE '%$HTTP_POST_VARS[leerjaar]%' AND 'vak' LIKE '$HTTP_POST_VARS[vak]%')"; $qSelect_berichten = mysql_query($sql) or die (mysql_error()); while($aBerichten = mysql_fetch_array($qSelect_berichten)) { echo '<tr> <td width="50px"><p class="style4">'.$aBerichten['leerjaar'].'</p></td> <td width="50px"><p class="style4">'.$aBerichten['vak'].'</p></td> <td width="50px"><p class="style4">'.$aBerichten['lesonderwerp'].'</p></td> <td width="30%"><p class="style4">'.$aBerichten['doelstelling'].'</p></td> <td width="20px"><p class="style4">'.$aBerichten['ict'].'</p></td> <td width="30%"><p class="style4"><a href="'.$aBerichten['ict2'].'">1</a></p></td> </tr>'; } echo '</table>'; }