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

Re: [4cdg] Searching accounts table

By Jason - February 16, 2012

Hi,

It's hard to say exactly what the problem is without being able to see the query in action.

If you could fill out a [url http://www.interactivetools.com/support]2nd Level Support Request[/url] I can take a look and see what I can find.

Thanks,
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/