nick_whitmarsh Posted June 6, 2007 Share Posted June 6, 2007 Hello again, we have a query, which is designed to search for users in a table. At current this is $query = 'SELECT * FROM member WHERE fname LIKE "%' . $_GET['people'] . '%" OR sname LIKE "%' . $_GET['people'] . '%" OR ORDER BY sname; '; This works if i search something like 'Nick' or 'n', but if i want to search for a whole name like joe bloggs then it does not work. Does anyone know how I can fix it. Cheers in advance N Quote Link to comment https://forums.phpfreaks.com/topic/54422-solved-search-query/ Share on other sites More sharing options...
Psycho Posted June 6, 2007 Share Posted June 6, 2007 $query = 'SELECT * FROM member WHERE fname LIKE "%' . $_GET['people'] . '%" OR sname LIKE "%' . $_GET['people'] . '%" OR CONCAT(fname, ' ', sname) LIKE "%' . $_GET['people'] . '%" ORDER BY sname; '; Your other option is to use full text search which will find matches on any "word" in the search string, but that requires some changes in your database structure. I believe there is a tutorial on this site regarding that. Quote Link to comment https://forums.phpfreaks.com/topic/54422-solved-search-query/#findComment-269140 Share on other sites More sharing options...
nick_whitmarsh Posted June 6, 2007 Author Share Posted June 6, 2007 Cheers mate. That is working for now and I will have to make it more efficient later. Quote Link to comment https://forums.phpfreaks.com/topic/54422-solved-search-query/#findComment-269194 Share on other sites More sharing options...
Psycho Posted June 6, 2007 Share Posted June 6, 2007 please mark the thread as solved. Quote Link to comment https://forums.phpfreaks.com/topic/54422-solved-search-query/#findComment-269196 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.