CodingForums.com - View Single Post

SlayerACC · 02-20-2013, 09:15 PM

This is what I currently have..

PHP Code:


			
SELECT * FROM campgrounds WHERE (`name` LIKE'%$find%') OR (`city` LIKE'%$find%') OR (`notes` LIKE'%$find%') OR (`moreinfo` LIKE'%$find%') OR (`amenities` LIKE'%$find%') ORDER BY `name`

Using this search..

I would search for New Old Town and it would give me 0 results.
if I just search town I get 15 results
if I search just old I get 20 results
and if I search for new I get 7 results.

Not sure what I have done wrong.

Thanks... all help appreciated.

Slayer.

02-20-2013, 09:15 PM	PM User \| #3
SlayerACC Regular Coder Join Date: Sep 2009 Location: Calgary, Alberta Posts: 222 Thanks: 45 Thanked 3 Times in 3 Posts	This is what I currently have.. PHP Code: SELECT * FROM campgrounds WHERE (`name` LIKE'%$find%') OR (`city` LIKE'%$find%') OR (`notes` LIKE'%$find%') OR (`moreinfo` LIKE'%$find%') OR (`amenities` LIKE'%$find%') ORDER BY `name` Using this search.. I would search for New Old Town and it would give me 0 results. if I just search town I get 15 results if I search just old I get 20 results and if I search for new I get 7 results. Not sure what I have done wrong. Thanks... all help appreciated. Slayer. Last edited by SlayerACC; 02-20-2013 at 09:19 PM..