Searching accounts table

2 posts by 2 authors in: Forums > CMS Builder
Last Post: February 16, 2012   (RSS)

By 4cdg - February 16, 2012

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