Programming Forums - View Single Post

raikkonen · Oct 31st, 2005, 2:16 AM

thanks,guess i could only use that way. But say if i enter keywords into the search textbox using a comma as in 'cat,dog,mouse' it doesnt work? instead it doesnt give me any output at all. how do i implement the commas?

i tried your code..well it gave me this error : expected end of statement

sql="select * from news where keywords="keyword1" or keywords="keyword2" or keywords="keyword3" or keywords="keyword4""

whats wrong? missing " or .. ?

Oct 31st, 2005, 2:16 AM	#3
raikkonen Newbie Join Date: Jun 2005 Posts: 29 Rep Power: 0	thanks,guess i could only use that way. But say if i enter keywords into the search textbox using a comma as in 'cat,dog,mouse' it doesnt work? instead it doesnt give me any output at all. how do i implement the commas? i tried your code..well it gave me this error : expected end of statement sql="select * from news where keywords="keyword1" or keywords="keyword2" or keywords="keyword3" or keywords="keyword4"" whats wrong? missing " or .. ?