[ic] Search Results

[interchange-users@interchange.redhat.com (Bill Carr)]

On Tue, 2002-06-04 at 01:18, Sexy Little Devils wrote:
> I've built a successful dating site using Interchange.  I'm trying to add a
> new feature to the site which shows "Top Listed Members" at the top of the
> search results page.  I'd only like 6 shown.. they can see the rest by
> clicking 'more' (or something to that affect).
> 
> I'd like to use a SQL query (something like this):
> 
> [query sql="select member_code from members where member_toplisted >= '1'"
>          type=list
>            ml=6]
> 
> The only problem I'm having is formatting the data so it shows correctly.
> The easiest way to explain it is to have someone look at the actual page,
> the HTML frontend is already built, just needs the code.  What you will see
> at the top of the search results page is obviously place holder names while
> that piece is "under construction".
> 
> When a member purchases this feature, the value of member_toplisted will be
> updated to "30" or however many days they purchase.  Each night at midnight,
> a cronjob decrements the value by 1.  If possible, I'd like the newest (or
> highest value), show in the #1 spot and so forth.  The "more" page will
> simply show ALL members with [if value member_toplisted] in a SQL statement
> and I will sort them by highest value (I can handle this part).
Try it like this:
[query sql="select member_code from members where member_toplisted >= '1' ORDER BY member_toplisted DESC"
          type=list
            ml=6]

-- 
Bill Carr
Worldwide Impact
bill@worldwideimpact.com
413-253-6700