Select multiple rows from MySQL table

Question

I have a session that contains an array and that array is filled with id's. What is the best way to select all the rows from a MySQL table that correspond to these id's?

So I need something like:

SELECT * FROM table WHERE id = $_SESSION['ids']

Obviously, this doesn't work, since $_SESSION['ids'] is an array.

You will have to use the IN() MySQL syntax and loop through your IDs into the IN() — MonkeyZeus
– MonkeyZeus, Commented Oct 8, 2013 at 11:58
for using IN with an array, you first need to break the string. for find_in_set it would not be necessary — AdrianBR
– AdrianBR, Commented Oct 8, 2013 at 12:01

plain jane · Accepted Answer · 2013-10-08 12:02:32Z

3

     SELECT * 
     FROM 
        table
     WHERE 
         find_in_set(id, $_SESSION['ids'])>0

edited Oct 8, 2013 at 12:02

plain jane

1,0041 gold badge8 silver badges19 bronze badges

answered Oct 8, 2013 at 11:59

AdrianBR

2,5781 gold badge17 silver badges29 bronze badges

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

2 Comments

joepd Over a year ago

I tried the following to test your method: $_SESSION['ids'] = array(1,2,3); $db->query('SELECT * FROM table WHERE find_in_set(id, $_SESSION['ids'])>0'); It produces an error that I can't fix: Unknown column 'Array' in 'where clause'

AdrianBR Over a year ago

print $_SESSION['ids'] ; find in set needs it in the form of a quoted string such as "1,2,3,4,5". Make sure you are echoing it in the right format.

Spell · Accepted Answer · 2013-10-08 12:00:52Z

2

You can just use IN SQL operator. In this case your query will look like

$sql = 'SELECT * FROM table WHERE id IN ("' . implode('","', $_SESSION['ids'] . '")';

This code will produse a query like following:

SELECT * FROM table WHERE id IN ("1", "2", "foo");

Hope it helps

answered Oct 8, 2013 at 12:00

Spell

8,7582 gold badges19 silver badges19 bronze badges

Comments

rohitr · Accepted Answer · 2013-10-08 11:59:32Z

1

HI Try This,

 $var = $_SESSION['ids'];

 and then fire your query as

 $sql = SELECT * FROM table WHERE id = '$var';

answered Oct 8, 2013 at 11:59

rohitr

3712 silver badges11 bronze badges

Collectives™ on Stack Overflow

Select multiple rows from MySQL table

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related