[FX.php List] Need help building search into website

John Rice jrice at lawgistix.net
Thu Nov 9 15:30:44 MST 2006


Help! I'm trying to build search into my website. I've gotten it to  
return all records in a Filmaker database, but can't get it to return  
an exact match. For instance, I want to find "Pleva" exactly. The  
code looks like this:

<?php

include_once ('FX.php');
include_once ('server_data.php');
require_once('FMErrors.php');

$query = new FX("127.000.1.9", "80"); // IP address and
                                      // port of the Web
                                      // Companion
$query-> SetDBData('ffc_webdata.fp7' , 'web_completedsettlements');


$query-> SetDBPassword(FM_PASSWORD , FM_USERNAME);

$query->AddDBParam ('creditorName', $_POST['creditorName']);

$result = $query->FMFind();

if ($result['foundCount'] == 0) {
   echo "No records matched your selection. Please try
   again";
}  else {
   echo "Search Results<br><br><br>";
   echo "<table with=60% border=1>";
   echo "<tr><td>Creditor Name";
   foreach ($result['data'] as $recordKey =>$recordData) {
     echo "<tr>";
     echo "<td>".$recordData['creditorName'][0]."</td>";
     echo "</tr>";
   }
   echo "</table>";
}
?>



Any help would be greatly appreciated! Thank you!


More information about the FX.php_List mailing list