PHP , Mysql selecting row

Question

I seem to be having some difficulties with retrieving data from Mysql.

I tried this in PhpMyAdmin SQL:

SELECT *
FROM `ads1`
WHERE state IN ( 'Romania , Germany' )

and the code works but nothing gets returned.

I have a table with value in it and a PHP variable having this format: name1,name2,name3,....,nameN, all in one variable.

Now the idea is that if the table value is contained in the PHP variable, the row get's selected.

Do you guys suggest anything?

WHERE state IN ('Romania', 'Germany'). Also note that if your database is not case insensitive you will not get results if your search isn't the same case. To be honest, this seems like you're not really up to speed on this, and you'd be better suited reading tutorials. Make sure you read up on SQL Injection attacks and how to prevent them. — MetalFrog
– MetalFrog, Commented Jul 26, 2012 at 16:53

juergen d · Accepted Answer · 2012-07-26 16:52:53Z

3

SELECT * FROM ads1 WHERE state IN ( 'Romania' , 'Germany' )

You have to put every entry in quotes and not just the hole input.

answered Jul 26, 2012 at 16:52

juergen d

205k40 gold badges303 silver badges377 bronze badges

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

5 Comments

southpaw93 Over a year ago

aha , I see , but how do I assign N words to variables and then put those N variables inside the quotes ?

David Chan Over a year ago

you can fix your formatted variable to the correct format with implode("','", explode(',',$variable))

juergen d Over a year ago

I am not quite sure wha you wan to achive. Maybe you can add an example to your question.

southpaw93 Over a year ago

Well , I have an ads website , which allows the user to choose the states that he wants to see the ads from. The ad will have the state stored in the column xyz , and the user will have a column named stateschoosed which will have all the states that he chooses to see the ads from , like "Romania , Germany , United States of America , Somalia" and so on... . If the state of the ad is among the users choices then the ad gets selected and shown ,I hope you get the idea.

southpaw93 Over a year ago

@David Chan , you method worked :D ,that's great man , thank you :) so much :)

Collectives™ on Stack Overflow

PHP , Mysql selecting row

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related