MySQL SELECT query IN PHP Array

Question

I have a PHP array and what I am trying to do is use that in my MySQL query to select only the ones that are in the array.

I have this:

SELECT * FROM table IN ('.implode(',', $array).')

I guess what needs to happen is I need quotes around each array item for this to work. Right now it just has one, two, three, four where it should be "one", "two", "three", "four"

How could I do that? Or is there another way to do what I am looking for?

Thanks!

check this link you can find your answer [stackoverflow.com/questions/907806/… [1]: stackoverflow.com/questions/907806/… — Arun Kumar
– Arun Kumar, Commented Oct 16, 2011 at 1:56
I hope you've remembered to pass the strings in your array through mysql_real_escape_string() first. — Ilmari Karonen
– Ilmari Karonen, Commented Oct 16, 2011 at 3:29

imm · Accepted Answer · 2011-10-16 01:48:50Z

4

This would do it,

"'" . implode("','", $array) . "'"

answered Oct 16, 2011 at 1:48

imm

5,9391 gold badge29 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL SELECT query IN PHP Array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related