The error I get:
Fatal error: Call to undefined method MDB2_Error::fetchRow() in C:\xampp\htdocs\OrcaTools\includes\orcatools.inc on line 193
The query string:
SELECT gv.variety FROM grape_variety gv, wine_variety wv, wine w WHERE w.wine_id = wv.wine_id AND wv.variety_id = gv.variety_id AND w.wine_id = ORDER BY wv.id
This is the function - line 193 is marked with <-:
- Code: Select all
// Find the varieties for a wineID
function showVarieties($connection, $wineID)
{
// Find the varieties of the current wine,
// and order them by id
$query = "SELECT gv.variety
FROM grape_variety gv, wine_variety wv, wine w
WHERE w.wine_id = wv.wine_id
AND wv.variety_id = gv.variety_id
AND w.wine_id = {$wineID}
ORDER BY wv.id";
$result = $connection->query($query);
print $query;
if (MDB2::isError($result))
trigger_error($result->getMessage(), E_USER_ERROR);
$varieties = "";
// Retrieve and print the varieties
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC)) // <-<-<-<- line #193
$varieties .= " {$row["variety"]}";
return $varieties;
}
So, why isn't this working?