MySQL Select where two fields are in multidimensional array

Question

I have the following multidimensional array, generated after some database Selects:

<?php
$array = array (
    array("X"=>500, Y="400"),
    array("X"=>234, Y="347"),
    array("X"=>845, Y="345"),
    array("X"=>264, Y="916")
);
?>

Now I need to do a select in a table where BOTH field X and Y are in the array. How to do that? Like:

SELECT FROM table WHERE 
                        (X=500 AND Y=400) OR
                        (X=234 AND Y=347) OR
                        (X=845 AND Y=345) OR
                        (X=264 AND Y=916)
;

I can only find solutions here on StackOverflow for a single item in a query, but not for two values in a multidimensional array that needs to be exactly the same. Thank you!

Not sure I understand - what isn't working for you here?

Jay Blanchard
– Jay Blanchard

2015-07-15 14:54:44 +00:00
Commented Jul 15, 2015 at 14:54 — Jay Blanchard
– Jay Blanchard, Commented Jul 15, 2015 at 14:54

ital0 · Accepted Answer · 2015-07-16 13:00:45Z

1

If I understood, you need to read your array and pass it to your SQL.

Something like:

<?php

$where = null;
foreach ($array as $a)
{
    if (is_null($where))
    {
        $where = " WHERE (X = " . $a['X'] . " AND Y = " . $a['Y'] . ")";
    }else
    {
        $where .= " OR (X = " . $a['X'] . " AND Y = " . $a['Y'] . ")";
    }
}

$sql = "SELECT * FROM table " . $where;
?>

Hope it helps.

edited Jul 16, 2015 at 13:00

answered Jul 15, 2015 at 14:59

ital0

3442 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

MySQL Select where two fields are in multidimensional array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related