Problematic mysql query how to filter by multiple ID's

Question

Full code I use:

 $query18 = 'SELECT group_concat(id) as qc10 FROM tblorders WHERE date LIKE \'' . date ('Y-m-') . '%\'';
    $result18 = mysql_query($query18);
    $data18 = mysql_fetch_array($result18);
    $qc10 = $data18['qc10'];
  $query19 = "SELECT count(id) as qc11 FROM bl_orderitems WHERE orderid=$qc10";
    $result19 = mysql_query($query19);
    $data19 = mysql_fetch_array($result19);

$query19 looks like this:

'SELECT count(id) FROM bl_orderitems WHERE orderid=7,6,8,9,10,11,12,13,14';

But it doesn't work. How can I list those ID's so it would actually work?

THANKS!

redmoon7777 · Accepted Answer · 2012-01-17 01:20:36Z

5

use WHERE orderid IN(7,6,8,9,10,11,12,13,14)

so the query would be:

'SELECT count(id) FROM bl_orderitems WHERE orderid IN(7,6,8,9,10,11,12,13,14)';

answered Jan 17, 2012 at 1:20

redmoon7777

4,5361 gold badge26 silver badges26 bronze badges

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

Comments

John Petrak · Accepted Answer · 2012-01-17 01:21:20Z

3

Try using IN

SELECT count(id) FROM bl_orderitems WHERE orderid IN (7,6,8,9,10,11,12,13,14)

answered Jan 17, 2012 at 1:21

John Petrak

2,92822 silver badges32 bronze badges

Comments

jcmeloni · Accepted Answer · 2012-01-17 01:21:19Z

2

If you are looking to match a value for orderid that is one of those options that you listed, this should work:

SELECT count(orderid) FROM bl_orderitems WHERE orderid IN (7,6,8,9,10,11,12,13,14);

answered Jan 17, 2012 at 1:21

jcmeloni

1,2341 gold badge15 silver badges21 bronze badges

Collectives™ on Stack Overflow

Problematic mysql query how to filter by multiple ID's

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related