Multiple WHERE AND Querys - Mysql / PHP

Question

Trying to get the results of one query into the WHERE statement of another:

$query1 = "SELECT DISTINCT company_id FROM location WHERE state = 'XX'";
$result1 = mysql_query($query1) or die(mysql_error());
while($row1 = mysql_fetch_array($result1)) {
    //Collect WHERE STATEMENT HERE
}

I've tried the following:

$q1 = "SELECT company FROM company WHERE id = '16', id = '7' ORDER BY company";
$q1 = "SELECT company FROM company WHERE id = '16' AND id = '7' ORDER BY company";
$q1 = "SELECT company FROM company WHERE id = '16' && id = '7' ORDER BY company";

Along with other variations

Googling has only provided multiple WHERE AND if using different table names, but not the same. Anyone have any pointers?

the field 'id' cannot be 16 AND 7 at the same time. Use "or" — Nanne
– Nanne, Commented Aug 23, 2012 at 8:00

Community · Accepted Answer · 2017-05-23 11:56:15Z

1

for a generalized code :

$ids = array (
[0] => 2
[1] => 4
[2] => 19
[3] => 16
);  

$ids = join(',',$ids);  
$sql = "SELECT * FROM company WHERE id IN ($ids)";

reffer : same example

edited May 23, 2017 at 11:56

CommunityBot

11 silver badge

answered Aug 23, 2012 at 8:12

Nishant Jani

1,9918 gold badges30 silver badges41 bronze badges

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

1 Comment

Go3Team Over a year ago

I've had the best luck with this one, but for whatever reason, I am only getting 1 result ($query = "SELECT DISTINCT company_id FROM location WHERE state = 'XX'";) in the array when numrows tells me there should be 23. Doing print_r (mysql_fetch_array($result)); Only shows 1 result as well.

Arion · Accepted Answer · 2012-08-23 08:08:14Z

1

You could also use IN:

$x = array('16', '7');

$q1 = "SELECT company FROM company WHERE id IN(". implode(',', $x) .") ORDER BY company";

edited Aug 23, 2012 at 8:08

Arion

31.3k10 gold badges74 silver badges89 bronze badges

answered Aug 23, 2012 at 8:01

Mihai Stancu

16.2k2 gold badges35 silver badges51 bronze badges

Comments

Mihai Iorga · Accepted Answer · 2012-08-23 07:59:36Z

0

use OR

$q1 = "SELECT company FROM company WHERE (id = '16' OR id = '7') ORDER BY company";

answered Aug 23, 2012 at 7:59

Mihai Iorga

39.8k17 gold badges109 silver badges109 bronze badges

Collectives™ on Stack Overflow

Multiple WHERE AND Querys - Mysql / PHP

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related