SQL query with multiple parameters in where

Question

I have a simple database like this :

Name     id
-----------
music    1
sport    2
theatre  3

I just want to display

music

theatre

I call a function with the ids and want to show name corresponding, my query looks like this, but nothing happen

$array = array(1,3);
$id = implode(',', $array);
    
$result = doQuery("SELECT Name
                    FROM categories c
                    WHERE c.id IN '" . $id. "'
                    ");
                    
    if(hasRows($result)){
        while($row = mysql_fetch_row($result)){
            echo $row[0];
        }
    }

After making a DB call, it's often a good idea to check for errors. Also, you should note that you're learning a deprecated library -- consider switching to the newer mysqli or PDO extensions. — rutter
– rutter, Commented Jun 18, 2015 at 16:41
in requires () to be valid syntax, but depending on your flavor of sql (you didn't specify rdbms) you might need to either use a dynamic sql query, or split your delimited array into a table for in (select id from table) — Kritner
– Kritner, Commented Jun 18, 2015 at 16:44

Gideon Appoh · Accepted Answer · 2015-06-18 16:50:12Z

1

When you are using IN, you must place the conditions in parenthesis but in you case you are not using them so try something like this:

$array = array(1,3);
$id = implode(',', $array);

$result = doQuery("SELECT Name
                FROM categories c
                WHERE c.id IN (" . $id. ")
                ");

if(hasRows($result)){
    while($row = mysql_fetch_row($result)){
        echo $row[0];
    }
}

answered Jun 18, 2015 at 16:50

Gideon Appoh

6631 gold badge6 silver badges15 bronze badges

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

Comments

Karl Kieninger · Accepted Answer · 2015-06-18 16:49:27Z

0

I suspect you need your IN wrapped in ( ) not ' '.

$result = doQuery("SELECT Name
                   FROM categories c
                   WHERE c.id IN (" . $id. ")
                    ");

answered Jun 18, 2015 at 16:49

Karl Kieninger

9,1692 gold badges36 silver badges49 bronze badges

Collectives™ on Stack Overflow

SQL query with multiple parameters in where

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related