• 0

PHP Search


Question

First, excuse my English.... :blush:

How can I do to PHP Search engine in my list. My list has album names in front and when I click on the link the open pop-up menu where is songs.

</a><a href="java script:" onMouseDown="MM_openBrWindow('Link.htm','Name','scrollbars=yes,width=258,height=420')">Link name<br>

How I can add Search engine to my list like I enter the song name I search and then open pop-up album where this song is.

I hope that u understand.... but my English is terrible

Link to comment
Share on other sites

10 answers to this question

Recommended Posts

  • 0

Pfft, that's the slow way of doing it... Try:

SELECT * FROM table WHERE MATCH (fields) AGAINST ('search_string');

FULLTEXT support is awesome ;)

Link to comment
Share on other sites

  • 0

:p

ps how would you implement that code tim - something like this ?

&lt;?
require_once 'vars.php';

mysql_connect($dbserver,$dbuser,$dbpass);
@mysql_select_db($db);

if ($result=mysql_query("SELECT * FROM table WHERE MATCH (fields) AGAINST ('$query')")) {
  $row = mysql_fetch_array($result);
}

echo"$row[id], $row[base], $row[email]";

?&gt;

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.