I made a MySQL database with a dictionary in it. Above there is a form in wich you can specify some parameters. The problem is that the navigation doesn't work well. I always get the first 5 results. Can somebody help me out? There are about 56 records in the database.
The (not quite) working thing is on: http://www.oostendseverhalen.be/test_met_navigatie3.php <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <?php /* hieronder volgt het formulier */ echo ' <table width="100%" border="0" align="center" cellpadding="2"> <tr> <td height="198"> <form name="form1" method="post" action=""> <table width="100%" height="89" border="0" align="center" cellpadding="2" summary="interactief woordenboek Oostends nederlands, Engels en Frans."> <caption> <font color="#003399" size="6" face="Tahoma">Ostensche encyclopedie </font> </caption> <tr align="left" valign="middle" bordercolor="#000033" bgcolor="#CCFFFF"> <td width="33%" height="47" align="left" valign="middle"><em><strong><font size="2" face="Tahoma"> <label> <input name="taalkeuze" type="radio" value="woord_ost" checked> Oostends-Drooghenbroodt</label> <br> <label> <input type="radio" name="taalkeuze" value="woord_des"> Oostends-desnerck</label> </font></strong></em></td> <td width="22%" valign="middle"><p> <em><strong><font size="2" face="Tahoma"> <label> <input type="radio" name="taalkeuze" value="woord_nl"> Nederlands</label> <br> <label> <input type="radio" name="taalkeuze" value="woord_fr"> Frans</label> </font></strong></em></p></td> <td width="25%"><em><strong><font size="2" face="Tahoma"> <label> <input type="radio" name="taalkeuze" value="woord_eng"> Engels</label> <br> <label> <input type="radio" name="taalkeuze" value="verklaring"> Verklaring</label> </font></strong></em></td> <td width="20%"><div align="center"><font size="2" face="Tahoma">Hulp bij het zoeken</font></div></td> </tr> <tr align="left" valign="middle" bordercolor="#000033" bgcolor="#FFFFFF"> <td height="33" colspan="4" align="center" valign="top" bgcolor="#FFFFCC"><p><font size="2" face="Tahoma"> <input name="zoekwoord" type="text" id="zoekwoord2" value="" size="50" maxlength="40"> <input type="submit" name="Submit" value="Zoekn"> </font><font size="2" face="Tahoma"> </font></p> <blockquote> </blockquote></td> </tr> </table> </form> </tr> </table>'; if ($taalkeuze === NULL) { $taalkeuze = "woord_ost"; } $van = 0; $tot = 5; mysql_connect("**.**.**.**", "******", "********") or die (mysql_error()); $Query_beperkte_records = "SELECT woordenboek.* FROM woordenboek WHERE " .$taalkeuze. " LIKE '%" .$zoekwoord. "%' ORDER BY woordenboek.woord_ost ASC LIMIT ".$van.",".$tot; $Query_alle_records = "SELECT woordenboek.* FROM woordenboek WHERE " .$taalkeuze. " LIKE '%" .$zoekwoord. "%'"; $result = mysql("oostends",$Query_beperkte_records) or die(mysql_error()); $query = mysql("oostends",$Query_alle_records) or die(mysql_error()); $num3 = mysql_num_rows($query); $num2 = $num3 / $tot;. $num = ceil($num2);. if ($num > 1) { for ($i = 1; $i <= $num; $i++) $van2 = ($i * $tot) - $tot; if ($i == $page) $pages[$i] = "<font face=\"trebuchet ms\" color=\"#C0C0C0\"><b>$i</b></font>";. else $pages[$i] = "<font face=\"trebuchet ms\"><b><a href=\"$php_self?page=$i&van=$van2&tot=$tot\">$i</a></b></font>"; } $pages = implode("<b> | </b>", $pages); $vorige = ($page-1) ? "<font face=\"trebuchet ms\"><b><a href=\"$php_self?page=" . ($page - 1) . "&van=" . ($van - $tot) . "&tot=$tot\">< Vorige</a></b></font>" : ""; $volgende = ($page-$num) ? "<font face=\"trebuchet ms\"><b><a href=\"$php_self?page=" . ($page + 1) . "&van=" . ($van + $tot) . "&tot=$tot\">Volgende ></a></b></font>" : ""; if ($vorige && $volgende) $navigation = "$vorige | $pages | $volgende"; else $navigation = "$vorige | $pages | $volgende"; } print $navigation; while ($gegevens=mysql_fetch_object($result)) { echo "<table width=\"100%\" border=\"0\"cellpadding=\"2\" summary=\"oostends interactief woordenboek\"> <tr> <td width=\"18%\" colspan=\"1\" rowspan=\"2\"valign=\"top\"><div align=\"left\"><font color=\"#000080\" ><strong><font size=\"3\" face=\"Tahoma\">". $gegevens->woord_ost. "</strong></div></p>"; if ($gegevens->geluid != NULL) { echo "<a href=\"". $gegevens->geluid. "\"><img src=\"plaatjes/button_luister.gif\" width=\"21\" height=\"24\" border=\"0\"></a>";} else { echo ""; } echo " <a href=\"". $gegevens->geluid. "\"><img src=\"plaatjes/button_statistiek.gif\" width=\"21\" height=\"24\" border=\"0\"></a> <a href=\"". $gegevens->geluid. "\"><img src=\"plaatjes/button_stemmen.gif\" width=\"21\" height=\"24\" border=\"0\"></a><div align=\"left\"> </td> <td width=\"6%\" rowspan=\"2\" align=\"left\" valign=\"top\"><div align=\"left\"><strong><font size=\"1\" face=\"Tahoma\">Volgnr</font></strong></div></td> <td width=\"76%\" align=\"left\" valign=\"top\"><font color=\"#009966\"><strong><em><font face=\"Tahoma\">" .$gegevens->woord_des. "<font size=\"1\" ></strong> (ost_desn) , </em><font size=\"2\"><strong><em>" .$gegevens->woord_nl. "<font size=\"1\" ></strong> (nl) , <font size=\"2\"><strong><em>" .$gegevens->woord_fr. "<font size=\"1\" ></strong> (fr) , <font size=\"2\"><strong><em>" .$gegev ens->woord_eng. "<font size=\"1\" ></strong> (eng) , </em></strong><font size=\"2\"><font color=\"#000000\">" .$gegevens->verklaring."</div></td> </tr> <tr>"; if ($gegevens->multimedia != NULL) { echo "<td width=\"80%\" height=\"20%\" align=\"left\"><img src=\"" .$gegevens->multimedia. "\" width=\"170\" height=\"124\" border=\"1\"></td>"; } else { echo ""; } echo " </tr> </table>"; echo "<hr>"; } print $navigation; ?> </body> </html> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
