RAW MySQL in Zend Framework
Nice n Easy (once you know how)
$sdb = new Zend_Db_Table('table_name');
$select = "SELECT * FROM whatever";
$adapter = $sdb->getAdapter();
$query = $adapter->query($select);
$result = $query->fetchAll();
NOTE - its an array, not an object that gets returned
$result['id]
not $result->id
$sdb = new Zend_Db_Table('table_name');
$select = "SELECT * FROM whatever";
$adapter = $sdb->getAdapter();
$query = $adapter->query($select);
$result = $query->fetchAll();
NOTE - its an array, not an object that gets returned
$result['id]
not $result->id
