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 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. 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. 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. Link to comment https://forums.phpfreaks.com/topic/54422-solved-search-query/#findComment-269196 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.