Jump to content


Photo

Search Query in MYSQL


  • Please log in to reply
1 reply to this topic

#1 stimlict

stimlict
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 29 December 2003 - 10:09 PM

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.
What i just told you was false, what im about to tell you is true

#2 gizmola

gizmola
  • Administrators
  • Advanced Member
  • 4,664 posts
  • LocationLos Angeles, CA USA

Posted 29 December 2003 - 11:15 PM

your query syntax should be something like this:

SELECT col1, col2 FROM tablename
WHERE col2 LIKE \'%$searchphrase%\'




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users