# Keyword Search

**URL:** https://forum.kirupa.com/t/keyword-search/219613
**Category:** programming
**Created:** [March 18, 2007, 6:24pm UTC](https://forum.kirupa.com/t/keyword-search/219613 "2007-03-18T18:24:29Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![randomagain](https://avatars.discourse-cdn.com/v4/letter/r/35a633/32.png) [@randomagain](https://forum.kirupa.com/u/randomagain)
#### Post date: [March 18, 2007, 6:24pm UTC](https://forum.kirupa.com/t/keyword-search/219613/1 "2007-03-18T18:24:29Z")

</div>

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

```auto
 
<?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>

```