Pitsu Posted April 21, 2003 Share Posted April 21, 2003 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 More sharing options...
0 Tim Dorr Veteran Posted April 21, 2003 Veteran Share Posted April 21, 2003 Your english is ok with me :) How are you storing your list? MySQL db? Files? Link to comment Share on other sites More sharing options...
0 john smith 1924 Veteran Posted April 21, 2003 Veteran Share Posted April 21, 2003 SELECT * FROM <table> LIKE <query> ? Link to comment Share on other sites More sharing options...
0 Tim Dorr Veteran Posted April 22, 2003 Veteran Share Posted April 22, 2003 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 More sharing options...
0 john smith 1924 Veteran Posted April 22, 2003 Veteran Share Posted April 22, 2003 ah :) Link to comment Share on other sites More sharing options...
0 Pitsu Posted April 24, 2003 Author Share Posted April 24, 2003 Because I am very new one who deals with PHP so I exacly can't understand what are u meaning.... My list is here http://pitsu.klaabu.pri.ee/List/List.php Link to comment Share on other sites More sharing options...
0 Tim Dorr Veteran Posted April 24, 2003 Veteran Share Posted April 24, 2003 What is the data source of the list? Is it stored in a database or a file? Link to comment Share on other sites More sharing options...
0 Pitsu Posted April 24, 2003 Author Share Posted April 24, 2003 What is the data source of the list? Is it stored in a database or a file? File Link to comment Share on other sites More sharing options...
0 Tim Dorr Veteran Posted April 24, 2003 Veteran Share Posted April 24, 2003 So do you load all the data into an array? If so, you can use array_search() to find the data :) Link to comment Share on other sites More sharing options...
0 Pitsu Posted April 24, 2003 Author Share Posted April 24, 2003 Awful is to be a n00b :( ... Link to comment Share on other sites More sharing options...
0 john smith 1924 Veteran Posted April 24, 2003 Veteran Share Posted April 24, 2003 :p ps how would you implement that code tim - something like this ? <? 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]"; ?> Link to comment Share on other sites More sharing options...
Question
Pitsu
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