Re: [fw-general] Zend_DB_Table emulate this query

[Ian Warner]

Ignore this:

            try {

                // Lookup in the database Players that fit this word
                $table = new sites_lovefootball_models_Players();
                $where = 'MATCH (fname,sname) AGAINST ("Ashton")';
                $row   = $table->fetchRow($where);

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

            } catch (Exception $e) {
                echo 'Failed: ' . $e->getMessage();
            }

Ian Warner wrote:

Hi

Is it possible to emulate this in Zend_DB_Table:

SELECT A.team, B.fname, B.sname
FROM `teams` A, `players` B
WHERE MATCH (B.fname,B.sname) AGAINST ('Derby')
AND A.team_id = B.team_id;

So I have a join here and also some MySQL keywords, I have relations set up in my objects

Cheers

Ian