Hi
I am looking into keyword search, i have jivvyed this code… it makes senes in my head
the idea is that keywords are passed on to this page when clicking submit from another…
thanks
<?php
$connect = mysql_connect("localhost", "username","password")
// or die
mysql_select_db("sweets");
$results = NULL
if(issets($_GET['keywords']))
{
$sql ="SELECT *, MATCH(column a,column b) " .
"AGAINST('" . $_GET['keyword'] . "')AS score".
"FROM sweets".
"WHERE MATCH (column a,column b)".
"AGAINST('" . $GET['keywords']."')".
"ORDER BY score DESC";
$results = mysql_query($sql)
//or die
}
?>
echo --search results According to relivancy--
<table width ="300">
<?php
while ($row = mysql_fetch_array($results)){
extract($row);
echo"<tr><td align=\"center"">";
echo "<a href=\"individual.php?uidvar=". $uid."\">";
echo "image</a></td>";
echo "<td>";
echo "<a href=\"individual.php?uidvar=". $uid."\">";
echo $name
echo "</a></td>";
echo "<td>";
echo "<a href=\"individual.php?uidvar=". $uid."\">";
echo $descripton
echo "</a></td></tr>";
}
?>
</table>
</div>
</body>
</html>
