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 Link to comment https://forums.phpfreaks.com/topic/136231-i-have-given-up-search-problem/ 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? Link to comment https://forums.phpfreaks.com/topic/136231-i-have-given-up-search-problem/#findComment-710651 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)! Link to comment https://forums.phpfreaks.com/topic/136231-i-have-given-up-search-problem/#findComment-710657 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? Link to comment https://forums.phpfreaks.com/topic/136231-i-have-given-up-search-problem/#findComment-710661 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. Link to comment https://forums.phpfreaks.com/topic/136231-i-have-given-up-search-problem/#findComment-710662 Share on other sites More sharing options...
paulman888888 Posted December 9, 2008 Author Share Posted December 9, 2008 ok! Thankyou Link to comment https://forums.phpfreaks.com/topic/136231-i-have-given-up-search-problem/#findComment-710675 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.