MDB2 Query Result Format

PHP
1

I’ve hit a wall trying to get MDB2 to give me the results of my database query in the format I want. I’m probably misunderstanding something about MDB2, so please enlighten me.

The SQL below, when executed from a MySQL command line, returns what I want:

First Building Name
Second Building Name
Third Building Name
Forth Building Name

… so I know it’s not the SQL causing the problem.

Now the MDB2 code:

$sql = 'SELECT DISTINCT Property
	FROM Table1
	INNER JOIN Table2
	ON Table1.Id=Table2.Table1Id
	ORDER BY Property ASC';

$result = $mdb2->query($sql);
errorCheck($result);  // Check that result is not an error.
$data = $result->fetchAll(MDB2_FETCHMODE_ORDERED);  // Gives an array of all rows at once.
$result->free();  // Free all memory associated with queries.
print_r($data);

MDB2 returns the data in this format:

Array (
    [0] => Array (
            [0] => First Building Name
    )

    [1] => Array (
            [0] => Second Building Name
    )

    [2] => Array (
            [0] => Third Building Name
    )

    [3] => Array (
            [0] => Forth Building Name
    )
)

I want the data in this format instead:

Array (
    [0] => First Building Name

    [1] => Second Building Name

    [2] => Third Building Name

    [3] => Forth Building Name
)

Thank you :slight_smile:

Nick

2

If you read the documentation for MDB2 results, you will see that it cannot give you what you want.

So, you will need to rework the array afterwards so that it is formatted as you want it.

For example:


$data = $result->fetchAll(MDB2_FETCHMODE_ORDERED);
foreach ($data as $index => $row) {
    $data[$index] = $row[0];
}