1 reply to this topic

[LFFMHelp]

I'm attempting to use a form to allow users to narrow/filter results when searching our tech request system because we have quiet a few entries in our database. I'm hoping to return 15-20 requests per page and allow the user to use the FMSkipRecord feature to navigate through their returned results sorting the returned results by date/time modified. However when I perform a search that yields more than 15 results and click "next" the page loads a records found: 0, Displaying Records 1 through 0 result.

Here is the code:

<?php

// Inialize session
session_start();

// Value(s) from search_request.php
$completed = $_POST['completed'];
$database = $_POST['database'];
$lastname = $_POST['lastname'];
$description = $_POST['description'];
$school = $_POST['school'];
$problem = $_POST['problem'];
$assigned = $_POST['assigned'];

//Find number of records to skip and set Groupsize
if (! isset($skip) || $skip == '') {$skip = 0;}
if (! isset($FXE_groupSize) || strlen(trim($FXE_groupSize)) == 0) $FXE_groupSize = 15;

$query = new FX($serverIP, $webCompanionPort, $dataSourceType);
$query->SetDBData ("$database", "Main", "$FXE_groupSize");
$query->FMSkipRecords($skip);
$query->SetDBUserPass ($webUN, $webPW);
$query->AddDBParam('Completed?', $completed,'eq');
$query->AddDBParam('Last', $lastname, 'cn');
$query->AddDBParam('Description', $description,'cn');
$query->AddDBParam('School', $school,'eq');
$query->AddDBParam('Type', $problem,'eq');
$query->AddDBParam('Assigned_to', $assigned,'eq');
$query->AddSortParam ('Date Modified','descending'); // Sort by Date Modified
$query->AddSortParam ('Time Modified','descending'); // Sort by Time Modified
$result = $query->FMFind();
$records = $result['data'];
?>

In the HTML body:

<?php

echo '<p class="indent">Records Found: ' .$result['foundCount'].'</p>';
echo '<p class="indent">Displaying Records ' . ($skip + 1) . ' through ' . min(($skip + $FXE_groupSize), $result['foundCount'].'</p>');
echo '<br />';

if (strlen($result['linkPrevious']) < 1) {echo "<span class=\"medgraytext\">Prev</span>\n";}
else {echo '<a href="'.$result['linkPrevious']."\" class=\"bbody\">Prev</a>\n";}

if (strlen($result['linkNext']) < 1) {echo "<span class=\"medgraytext\">Next</span>\n";}
else {echo '<a href="'.$result['linkNext']."\" class=\"bbody\">Next</a>\n";}

foreach ($result['data'] as $key => $value) {

// Begin the Search Table

echo '<table id="Searchtable" cellspacing="0" summary="">';
echo '<caption>Job Priority: '.$value['Priority'][0].'</caption>';
echo '<tr>';
echo '<th scope="col" width="8%" abbr="Job Code" class="title">Job #</th>';
echo '<th scope="col" width="25%" abbr="Submitted By" class="header">Submitted By</th>';
echo '<th scope="col" width="25%" abbr="School" class="header">School - Location</th>';
echo '<th scope="col" width="20%" abbr="Problem" class="header">Type of Problem</th>';
echo '<th scope="col" width="22%" abbr="Equipment" class="header">Equipment</th>';
echo '</tr>';

echo '<tr>';
echo '<td class="start">'.$value['Job_Code'][0].'</td>';
echo '<td>'.$value['First'][0].' '.$value['Last'][0]. ' - '.$value['Phone'][0].'</td>';
echo '<td>'.$value['School'][0]. ' - '.$value['Location'][0].'</td>';
echo '<td>'.$value['Type'][0].'</td>';
echo '<td>'.$value['Machine_Type'][0].'</td>';
echo '</tr>';
echo '<tr>';
echo '<td colspan="5" class="description"><span class="submitted">On '.$value['Date submitted'][0].' '.$value['First'][0].' Wrote: </span><br /> '.$value['Description'][0].'<br /><br /><span class="techassigned">Currently Assigned to:</span> '.$value['Assigned_to'][0].'</td>';
echo '</tr>';
echo '<tr>';
echo '<td colspan="5" class="comments" >'.nl2br($value['Comments'][0]).'</td>';
echo '</tr>';
echo '<p class="minispace"></p>';
}
echo '</table>';
?>

It finds the right number of records to begin with i.e., it will state records found 20, displaying 1 through 15 records, however it just won't advance/backup any additional records. Thank you. Ken

[webko]

Well, you've only ever said $skip = 0 - you'll need to pull the skip value from your LinkNext / LinkPrevious links