Hi ,
I have a form submitting a select list values ( having multiple choise). to the search script.
Now I want to use that list in to sql query. so I am making it as a list.
<sum "'%s', " $productID>
<$searchID = (convert($ret, 'strlst'))>
where $productID is : abc3234 bdf3243 dfdc3434
so the result I am getting is :
'abc3234', bdf3243', dfdc3434',
How do I remove the last coma in the above list. Because when I am using that list in the query clause like:
select content from product_content where
product_id in ($searchID)
it doesn't filter the search instead return everything.
Any idea to remove the last comma from the list would be really help ful.
Thanks
I have a form submitting a select list values ( having multiple choise). to the search script.
Now I want to use that list in to sql query. so I am making it as a list.
<sum "'%s', " $productID>
<$searchID = (convert($ret, 'strlst'))>
where $productID is : abc3234 bdf3243 dfdc3434
so the result I am getting is :
'abc3234', bdf3243', dfdc3434',
How do I remove the last coma in the above list. Because when I am using that list in the query clause like:
select content from product_content where
product_id in ($searchID)
it doesn't filter the search instead return everything.
Any idea to remove the last comma from the list would be really help ful.
Thanks
