php mysql query strings array

Posted by Chocho on Stack Overflow See other posts from Stack Overflow or by Chocho
Published on 2010-04-14T13:35:05Z Indexed on 2010/04/14 13:43 UTC
Read the original article Hit count: 364

Filed under:
|
|
|
|

i am building a string that i check in mysql db.

eg:
formFields[] is an array - input1 is: string1
array_push(strings, formFields)
1st string and mysql query looks like this:
"select * from my table where id in (strings)"

formFields[] is an array - input2 is: string1, string2
array_push(strings, formFields)
2nd string and mysql query looks like this:
"select * from my table where id in (strings)"

formFields[] is an array - input3 is: string1, string2,string3
array_push(strings, formFields)
3rd string and mysql query looks like this:
"select * from my table where id in (strings)"

i will like to add single quotes and a comma to the array so that i have this for the array strings: "select * from my table where id in ('string1', 'string2','string3')"

i tried using array implode, but still no luck any ideas? thanks

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql