DB_FETCHMODE_ASSOC returns an ordered array using MsSQL
| From: | Frederic Trudeau | Date: | Thu, 26 Feb 2004 22:59:59 +0000 |
| Subject: | DB_FETCHMODE_ASSOC returns an ordered array using MsSQL | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-10973@lists.php.net to get a copy of this message | ||
Well, subject is pretty much self explanatory ...
$db = DB::connect('mssql://dbuser:dbpass@dbhost/dbname')
$sql = "SELECT * FROM sometable";
$res = $db->query($sql)
$row =& $res->fetchRow('DB_FETCHMODE_ASSOC');
print_r($row);
output is :
Array
(
[0] => 75
[1] => WOP_SSL
[2] => 0
[3] => {{wop_ssl}}
[4] =>
[5] => N
[6] =>
[7] => 0
[8] =>
[9] =>
[10] => G
[11] => NETWORK
[12] => G
[13] => NETWORK
[14] => G
[15] => NETWORK
[16] =>
[17] =>
)
help ? : )