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, Oct 08 '13 at 11:58
duplicate: http://stackoverflow.com/questions/9476146/mysql-php-select-where-id-array — cptnk, Oct 08 '13 at 11:59
for using IN with an array, you first need to break the string. for find_in_set it would not be necessary — AdrianBR, Oct 08 '13 at 12:01

score 3 · Answer 1 · edited Oct 08 '13 at 12:02

3

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

edited Oct 08 '13 at 12:02

plain jane

1,009
1
8
19

answered Oct 08 '13 at 11:59

AdrianBR

2,762
1
15
29

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' – joepd Oct 09 '13 at 09:35
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. – AdrianBR Oct 09 '13 at 10:09

score 2 · Accepted Answer · answered Oct 08 '13 at 12:00

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

score 1 · Answer 3 · answered Oct 08 '13 at 11:59

1

HI Try This,

 $var = $_SESSION['ids'];

 and then fire your query as

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

answered Oct 08 '13 at 11:59

rohitr

371
2
11

Select multiple rows from MySQL table

3 Answers3