Hello, wondered if anyone can point me in the right direction.
I'm using a database created by someone else which I don't want to change if I can help it. I'm creating a concatenated string from the results of 3 fields returned from a database query. (hense I can't use a join or advanced select statement)
EXAMPLE:
field_default = K
field_option = M,J,S,A,B,
field_ext_option = D,W,P,
$myOptions = K,M,J,S,A,B,D,W,P //concatenated string
//convert the string to an array
$myOptionsArray = explode (",",$myOptions);
I now need to loop through this array to bring back all of the 'products' equal to the options in $myOptionsArray.
I've tried to grab each element in the array and loop through the table to find the relevent 'products' but the while loop breaks out only returning the first 'product'.
Any ideas
Thanks in advance
