Need to search accounts table by field dogbreeds. For some reason this is not working. I have setup numerous search forms that successfully search mult-record tables. I think this may be an issue with the accounts table because i get no valid results.
Here is the code for my search form
<form method="get" action="breederResults.php">
<table border="0" align="center" cellpadding="5" cellspacing="0" class="arial_14">
<tr>
<td>Search by Breed:</td>
<td><input name="dogbreeds_query" type="text" value="" size="50" /></td>
<td><input type="submit" name="submit" value="Search"></td>
</tr>
</table>
</form>
here is the code at top of search page and this is on the results page too
// load records
list($accountsRecords, $accountsMetaData) = getRecords(array(
'tableName' => 'accounts',
'orderBy' => 'fullname',
'where' => "type='Annual' OR type='Breeder Only'",
));
I also load records from another table on the pages to display ads but i have 'allowSearch' => false, on those records. the page is here
http://www.findaguarddog.com/find_breeder.php