Re: [design9] Alpha Search
Hi April,
So you want to be able to search for listings that start with a certain letter and belongs to a certain category. Is that right.
What you can do is add this information to a custom WHERE clause in your getRecords call.
For example, if we assume that we want to find all listings that start with the letter "A" (ie, "A" is the first letter in the title field) and belongs to the education category, we can set up a query that looks like this:
list($listingsRecords, $listingsMetaData) = getRecords(array(
'tableName' => 'listings',
'allowSearch' => false,
'where' => "title LIKE 'A%' AND category = 'education'",
));
Of course you'll have to change the category value based on how you're storing you category values in listings.
Hope this helps get you started.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/