paulman888888 Posted December 9, 2008 Share Posted December 9, 2008 I been trying (for a long time), to create a Mysql, PHP search engine. I can do simple ones but i can't do ones that search under different colums. Can you tell me a site please? Please help me Paul Hutchinson Quote Link to comment Share on other sites More sharing options...
premiso Posted December 9, 2008 Share Posted December 9, 2008 http://www.google.com/search?hl=en&q=create+a+php+search+engine&btnG=Google+Search http://www.developer.com/db/article.php/3671021 A site like the above? Quote Link to comment Share on other sites More sharing options...
paulman888888 Posted December 9, 2008 Author Share Posted December 9, 2008 I dont think you understand. Ill explain more. I have my data in a database and need a search engine to go though my database (more than one table to search)! Quote Link to comment Share on other sites More sharing options...
JonnoTheDev Posted December 9, 2008 Share Posted December 9, 2008 You need to elaborate. What is your current search query? What columns do you want to search? What columns do you want to return? Quote Link to comment Share on other sites More sharing options...
premiso Posted December 9, 2008 Share Posted December 9, 2008 I dont think you understand. Ill explain more. I have my data in a database and need a search engine to go though my database (more than one table to search)! Use a join and OR statements. SELECT * FROM table1 tb1, table2 tb2 WHERE tb1.tblid = tb2.tblid AND (tbl1.search like '%search%' OR tbl2.search like '%search%'); As long as tb1 and tb2 are identified by unique ids, if not do 2 seperate queries. Quote Link to comment Share on other sites More sharing options...
paulman888888 Posted December 9, 2008 Author Share Posted December 9, 2008 ok! Thankyou Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.