ordering FullText search results

[artka54]

Hello everybody!

I have a fulltext search script that orders the results by relevance to the keywords. 

 

But I want that  the order process takes into consideration column `views` as well.

So basically what I want is that relevance is 80% significant but views respectively - 20%.

 

I tried to figure out some ways, but as I am amateur there were only errors that came out.

 

Here ismMy code which is working and ordering the results ONLY 100% by revelance:

 

$mq = mysql_query("SELECT *, (MATCH(articles) AGAINST ('briniskigi housez lacitis' IN BOOLEAN MODE))
AS relevance FROM results
WHERE ( MATCH(articles) AGAINST 
('briniskigi housez lacitis' IN BOOLEAN MODE) ) ORDER BY relevance DESC");
while($row = mysql_fetch_array($mq))
{
   echo $row['id'] . '<br />';
}

 

Thank you in advance. I hope that you understood me

[MasterACE14]

ORDER BY

[artka54]

Thanks It helped me to solve the core problem, although I still can't do exactly what I wanted, but that seems to be too difficult for now anyway.