[mv] Limiting Search Results - search-region

["Cameron B. Prince" <cbp@internetexpertsllc.com>]

******    message to minivend-users from "Cameron B. Prince" <cbp@InternetExpertsLLC.com>     ******

Hi list,

I need to limit what is displayed on a search results page based on what a
certain column is set to.

I did this with an SQL query as follows: (WHERE status = 'paid')

[query st=db arrayref=orders
		sql="SELECT
			code,status,due_date,total_cost,invoice_date,company
			FROM invoices
			WHERE status = 'paid'
			ORDER by code
		"][/query]


Can anyone advise me how to limit search results in the same way?

I need to limit the results to only those invoices that have a status of
paid.

Here is the search code I am using:

[set first_done][/set]
[search-region more=1 search="
		ra=yes
		st=db
		fi=invoices
		ml=999999
		tf=invoice_number
		"]

[search-list]


item-data.......


[/search-list]

[/search-region]



I have looked through the docs on this and it's unclear to me how to achieve
this. Any help would be greatly appreciated.


Thanks,

Cameron


-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list