Problem iterating thru associative array created by using SQL query.

[pbali]

Hi,

I am using PHP 5.1 and MySQL. I have a result set obtained by executing
PDO:: query. I want to create an XML file by using this result set. The
XML file will contain column names as XML node name and column values
as node values.

$orders = $db->query($sql);

if (!empty($orders )) {

foreach ($orders as $row) {

foreach($row as $key=>$value) {
print $key . " => " . $value . "<br>";
// XML Elements will be created here...
}
}
}

The result of this loop as follows:

orderID => 1
0 => 1
packageSKU => SKU1
1 => SKU1
fullName => John Doe
2 => John Doe
address =>address1
3 =>address1
city => city1
4 => city1
itemTypeLabel => mailer
5 => mailer

When I am iterating through foreach loop, I am getting associative
array names and indices together. For example, after getting orderID as
$key in the first run, I am getting 0 as $key in the second run, etc.
which I don't want to. I just want to use the associative array names.

I appreciate if you can let me know if you have any idea what might be
the reason.

Thanks in advance.

Sincerely,

Pelin Bali.

[Carl]

Pelin,

Try changing the line
$orders = $db->query($sql);
to :
$orders = $db->query($sql, PDO::FETCH_ASSO C);

I don't know why that option is not shown on the php.net docs for PDO,
but it does infact work for me (php 5.1.2)

More info can be found here:
http://wiki.cc/php/PDO_Basics#Query_a_table

Hope that helps,
Carl.

[Iván Sánchez Ortega]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

pbali wrote:

I appreciate if you can let me know if you have any idea what might be
the reason.

RTFM:

http://php.net/mysql_fetch_array

And check the documentation of your DB abstraction layer, to see if it's
possible to change between MYSQL_ASSOC, MYSQL_NUM and MYSQL_BOTH.

- --
- ----------------------------------
Iván Sánchez Ortega -i-punto-sanchez--arroba-mirame-punto-net

http://acm.asoc.fi.upm.es/~mr/ ; http://acm.asoc.fi.upm.es/~ivan/
MSN:i_********* *************** *@hotmail.com
Jabber:iv****** ***@jabber.org ; iv*********@kde talk.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)

iD8DBQFED2EI3jc Q2mg3Pc8RAn9SAJ 4kf0YGvBvxCViO2 CpsnjCBB6fYyACe PyTF
A5hxQWZWt/auC/F/fpYqKZo=
=SF+8
-----END PGP SIGNATURE-----

[pbali]

Thanks Carl,

That worked. *:)

-Pelin.