Re: querying comma seperated values in a db field?
OK. I am trying everything and nothing is working so now I am thinking that I could use split on the $dbins_fd_ref before it gets to the sql query (splitting on the commas) which should split the comma separated values into array elements, no?
Then I should be able to use something such as:
WHERE product_xcat LIKE $array[0,1,2,3,4]
If this doesnt work is there a way to do this in an OR fasion such as:
WHERE product_xcat LIKE $array[0] OR $array[1] ...
This is getting frustrating. Thanks for helping!
Subject
Written By
Posted
September 27, 2006 11:39PM
September 27, 2006 11:50PM
September 28, 2006 12:36AM
September 28, 2006 09:21AM
September 28, 2006 09:49AM
September 28, 2006 10:07AM
September 28, 2006 10:25AM
September 28, 2006 01:31PM
September 28, 2006 02:21PM
September 28, 2006 02:38PM
September 28, 2006 03:29PM
September 28, 2006 03:38PM
September 28, 2006 03:43PM
Re: querying comma seperated values in a db field?
September 28, 2006 06:00PM
September 28, 2006 06:11PM
September 28, 2006 06:50PM
September 28, 2006 07:08PM
September 28, 2006 07:25PM
September 28, 2006 10:13PM
September 29, 2006 05:25AM