Welcome Guest, Not a member yet? Register   Sign In
Help creating a search model for my new website
#2

[eluser]thinkigniter[/eluser]
Try
Code:
if (strlen($search_words) < 4) {    
            $query = $this->db->query("SELECT * FROM songs WHERE deadlink='No' AND artistName LIKE '%". $search_words ."%' OR title LIKE '%". $search_words ."%' LIMIT $offset, $num ");
        }

Add '%' for containing keyword


Messages In This Thread
Help creating a search model for my new website - by El Forum - 12-17-2008, 02:08 PM
Help creating a search model for my new website - by El Forum - 12-17-2008, 04:27 PM
Help creating a search model for my new website - by El Forum - 12-17-2008, 04:34 PM
Help creating a search model for my new website - by El Forum - 12-17-2008, 07:38 PM
Help creating a search model for my new website - by El Forum - 12-17-2008, 09:35 PM
Help creating a search model for my new website - by El Forum - 12-17-2008, 10:26 PM
Help creating a search model for my new website - by El Forum - 12-17-2008, 11:06 PM
Help creating a search model for my new website - by El Forum - 12-18-2008, 05:59 AM
Help creating a search model for my new website - by El Forum - 01-12-2009, 10:23 AM
Help creating a search model for my new website - by El Forum - 01-12-2009, 07:20 PM
Help creating a search model for my new website - by El Forum - 01-12-2009, 07:30 PM
Help creating a search model for my new website - by El Forum - 01-14-2009, 08:50 AM
Help creating a search model for my new website - by El Forum - 01-15-2009, 06:33 AM
Help creating a search model for my new website - by El Forum - 01-15-2009, 12:48 PM
Help creating a search model for my new website - by El Forum - 01-16-2009, 10:30 PM



Theme © iAndrew 2016 - Forum software by © MyBB