Weighted Full Text Search Question

[Alkaline]

Ok, how to do this efficiently escapes me, so I'm going to ask and see
if anyone might have ideas.

My problem is really simple. I have a database filed with user
comments. It's basic fields are an id (primary key), a user id (of the
user who submitted the comment), and the comment itself.

I have a separate user database that contains an id, the user name,
and the user's trustworthiness.

Now I want to do a fulltext search of the comment database using its
comment field.

Here is where I'm having trouble: I want to give the comments
submitted by more trusted users a higher weight in the search so that
they are more likely to come out on top.

I've been reading and have yet to find a good way to do this. Any
ideas?

Help is much appreciated.

[Aggro]

Alkaline wrote:

Here is where I'm having trouble: I want to give the comments
submitted by more trusted users a higher weight in the search so that
they are more likely to come out on top.

I've been reading and have yet to find a good way to do this. Any
ideas?

Add field: trust_value to your table (either to comment or user table,
depending on what you want), and add "order by trust_value" to your query.

[Aggro]

Alkaline wrote:

Here is where I'm having trouble: I want to give the comments
submitted by more trusted users a higher weight in the search so that
they are more likely to come out on top.

I've been reading and have yet to find a good way to do this. Any
ideas?

Add field: trust_value to your table (either to comment or user table,
depending on what you want), and add "order by trust_value" to your query.

[Aggro]

Alkaline wrote:

Here is where I'm having trouble: I want to give the comments
submitted by more trusted users a higher weight in the search so that
they are more likely to come out on top.

I've been reading and have yet to find a good way to do this. Any
ideas?

Add field: trust_value to your table (either to comment or user table,
depending on what you want), and add "order by trust_value" to your query.

[Alkaline]

Aggro <sp**********@yahoo.com> wrote in message news:<Ed***********@read3.inet.fi>...

Alkaline wrote:

Here is where I'm having trouble: I want to give the comments
submitted by more trusted users a higher weight in the search so that
they are more likely to come out on top.

I've been reading and have yet to find a good way to do this. Any
ideas?

Add field: trust_value to your table (either to comment or user table,
depending on what you want), and add "order by trust_value" to your query.

But if I have a query like:

SELECT users.name,users.location,comments.comment FROM users JOIN
comments
ON (users.id = comments.userid) WHERE MATCH (comment) AGAINST
('sorta');

and then I add an "ORDER BY trust_value" thing to it, won't it first
order by relevancy and then within that order by trust?

[Alkaline]

Aggro <sp**********@yahoo.com> wrote in message news:<Ed***********@read3.inet.fi>...

Alkaline wrote:

Here is where I'm having trouble: I want to give the comments
submitted by more trusted users a higher weight in the search so that
they are more likely to come out on top.

I've been reading and have yet to find a good way to do this. Any
ideas?

Add field: trust_value to your table (either to comment or user table,
depending on what you want), and add "order by trust_value" to your query.

But if I have a query like:

SELECT users.name,users.location,comments.comment FROM users JOIN
comments
ON (users.id = comments.userid) WHERE MATCH (comment) AGAINST
('sorta');

and then I add an "ORDER BY trust_value" thing to it, won't it first
order by relevancy and then within that order by trust?

[Alkaline]

Aggro <sp**********@yahoo.com> wrote in message news:<Ed***********@read3.inet.fi>...

Alkaline wrote:

Here is where I'm having trouble: I want to give the comments
submitted by more trusted users a higher weight in the search so that
they are more likely to come out on top.

I've been reading and have yet to find a good way to do this. Any
ideas?

Add field: trust_value to your table (either to comment or user table,
depending on what you want), and add "order by trust_value" to your query.

But if I have a query like:

SELECT users.name,users.location,comments.comment FROM users JOIN
comments
ON (users.id = comments.userid) WHERE MATCH (comment) AGAINST
('sorta');

and then I add an "ORDER BY trust_value" thing to it, won't it first
order by relevancy and then within that order by trust?