vbadvanced page

[prislea]

Hi,

I've made a php page for vbadvanced, it is a dictionary and the code look like this:


<?php

error_reporting(E_ALL & ~E_NOTICE);

define ('NO_REGISTER_GLOBALS', 1);
define ('THIS_SCRIPT', 'dictionar');
require_once('./global.php');

$rowsPerPage = 30;
$pageNum = 1;
$inx = 0;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}

$offset = ($pageNum - 1) * $rowsPerPage;


echo "<tr><td class=\"alt2\">"
."<div align=\"center\">"
."<form action=\"index.php?pageid=dictionar\" method=\"post\">"
.$vbphrase['dic_find'].":"
."<input type=\"text\" name=\"dicSearch\" size=\"26\">"
."<select name=\"searchType\">"
."<option selected value=\"exact\">".$vbphrase['dic_exact']."</option>"
."<option value=\"starts_with\">".$vbphrase['dic_starts']."</option>"
."<option value=\"ends_with\">".$vbphrase['dic_ends']."</option>"
."<option value=\"contains\">".$vbphrase['dic_contains']."</option>"
."</select>"
."<input type=Submit value=\"".$vbphrase['dic_search']."\">"
."</form>"
."</div>"
."<br />";

$dicSearch = $_POST['dicSearch'];
$searchType = $_POST['searchType'];

$searchTypeText = "='$dicSearch'";

if($searchType == "starts_with") {
$searchTypeText = " like '$dicSearch%'";
}
else if($searchType == "ends_with") {
$searchTypeText = " like '%$dicSearch'";
}
else if($searchType == "contains") {
$searchTypeText = " like '%$dicSearch%'";
}

if($dicSearch != "") {

$resultat = $db->query_read("SELECT * FROM " . TABLE_PREFIX ."dictionar_dictionary WHERE dic_word".$searchTypeText." order by dic_word LIMIT $offset, $rowsPerPage");

while(list($did, $dic_word, $dic_def) = $db->fetch_row($resultat)) {
echo "<br><strong>$dic_word</strong> <i>$dic_def</i><br>";
$inx++;
}

if($inx == 0) {
echo "<center><strong><i>$dicSearch</i> ".$vbphrase['dic_notfound']."</strong></center>";
}

echo "<br><center>";


$resultat = $db->query_read("SELECT COUNT(*) AS numrows FROM " . TABLE_PREFIX ."dictionar_dictionary WHERE dic_word".$searchTypeText);
$row = $db->fetch_array($resultat, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$rowsPerPage);
$self = $_SERVER['PHP_SELF'];
$nav = '';

for($page = 1; $page <= $maxPage; $page++)
{
if($page == $pageNum)
{
$nav .= " $page ";
}
else
{
$nav .= " <a href=\"$self?pageid=dictionar&amp;page=$page\">$page</a> ";
}
}

if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " <a href=\"$self?pageid=dictionar&amp;page=$page\">[".$vbphrase['dic_previous']."]</a> ";
$first = " <a href=\"$self?pageid=dictionar&amp;page=1\">[".$vbphrase['dic_first']."]</a> ";
}
else
{
$prev = '&nbsp;';
$first= '&nbsp;';
}

if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = " <a href=\"$self?pageid=dictionar&amp;page=$page\">[".$vbphrase['dic_next']."]</a> ";
$last = " <a href=\"$self?pageid=dictionar&amp;page=$maxPage\">[".$vbphrase['dic_last']."]</a> ";
}
else
{
$next = '&nbsp;';
$last= '&nbsp;';
}


echo $first . $prev . $nav . $next . $last;
echo "</center>";
echo "<BR>";
}

$totaldb = $db->num_rows($db->query_read("SELECT * FROM " . TABLE_PREFIX . "dictionar_dictionary"));
echo "<div align=\"right\"><FONT class=\"smallfont\" color=\"red\">".$vbphrase['dic_totaldb'].": $totaldb ".$vbphrase['dic_words']."</FONT></div>\n";

echo "</td></tr>";
?>


everything is working fine until I need to go to the next page. I am a beginner in php and programing in general and I dont know what the problem is.
when I click on the [next] link what looks like this
http://www.mysite.net/index.php?pageid=dictionar&page=2
I get the page without results like the begin page.

[Lynne]

For help on vbadvanced, you need to go to vbadvanced.com