fetch all and undefined index

slightlyeskew

Hey All!

I'm trying to start using more complex fetch methods in my querying. I pulled this from a php cookbook but its not working. When I run the script I get

Notice: Undefined index: Source_Certificate in /var/www/NovaDB/testvar.php on line 9

Notice: Undefined index: Source_Shareholder in /var/www/NovaDB/testvar.php on line 9

repeating many times.

The script:

<?php
error_reporting(E_ALL);
require_once 'MDB2.php';
$db = MDB2::connect('mysql://blah:blah@lblah/blah');
if (MDB2::isError($db)) { die("Can't connect: " . $db->getMessage()); }

$test = $db->query("SELECT Source_Certificate,Source_Shareholder FROM TransactionHistory");
foreach($test->fetchAll() as $row) {
	print "{$row['Source_Certificate']} {$row['Source_Shareholder']}<br/>\n";
}
?>

I've checked the spelling on all the different fields to make sure it wasn't something simple. I'd appreciate any advice you guys have. Thanks for your time!

halojoy

Here is from the MDB2 Manual ... about fetch
http://pear.php.net/manual/en/package.database.mdb2.intro-fetch.php

Use fetchRow()

foreach($test->fetchRow() as $row) {

jay6390

The reason for the errors is that $row is not what you expect. if you want to see the value of $row inside the foreach loop use

echo '<pre>'.print_r($row, true).'</pre>';

That will show you the contents of $row for each iteration of the loop

slightlyeskew

Thanks for the responses on this guys. I was expecting this method to loop through all the rows returned from the query though because of the foreach. When I compiled with either of your suggested changes the script only printed the first line. Any suggestions?