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

[Tom Sepper]

Change

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

To

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

---
Tom Sepper
Director of Information Technology
Director's Choice Tour & Travel

P 806.762.6354
F 806.763.7637

tsepper at dctandt.com
www.directorschoicetourandtravel.com

-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of John Rice
Sent: Thursday, November 09, 2006 4:31 PM
To: fx.php_list at mail.iviking.org
Subject: [FX.php List] Need help building search into website

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!
_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list