Jump to content

Archived

This topic is now archived and is closed to further replies.

stimlict

Search Query in MYSQL

Recommended Posts

i need a search script in which someone searches through my tables. I have 3 main tables, (news, articles, and famous diamonds) and in the drop down they need to select from which table. Then it has to beable to search... current example at the top i have is at

http://www.dakov.com

but the code gives me error

 

 

each table has different name for the table, title, and body for example in one table title column is title and in another its titlearticle, and third its namegia

 

i cant figure out how to query it from various tables from the database and display the results nicely

 

[php:1:10b1238074]<?php

$sql = \"

SELECT *,

MATCH($title, $body) AGAINST(\'$searchresult\') AS score

FROM $usertable

WHERE MATCH($title, $body) AGAINST(\'$searchresult\')

ORDER BY score DESC

\";

$rest = MySQL_query($sql);

?>

 

SCORETITLEID#

{$sql2[\'score\']}\";

echo \"{$sql2[\'title\']}\";

echo \"{$sql2[\'id\']}\";

}

echo \"\";

 

 

 

?>[/php:1:10b1238074]

 

Thanks guys.

Share this post


Link to post
Share on other sites

your query syntax should be something like this:

 

SELECT col1, col2 FROM tablename

WHERE col2 LIKE \'%$searchphrase%\'

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.