need to use resulted comma seperated values to search in database

prasad.mhatre's Avatar

prasad.mhatre

01 Mar, 2012 06:36 AM

Dear Friends,

Ok I got the results from the Autosuggest script like this

100,123,304 etc.

Now I need to use this result to query mysql database and show results of each comma seperated value one row below the other. I have no idea how to get the results using WHERE.

Any help is appreciated.

Thanks
Prasad

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac