Re: Zend DB Table - WHERE as OR?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Apr 9, 2010 at 3:15 PM, Dan Joseph <dmjoseph@xxxxxxxxx> wrote:
> Hi Everyone,
>
> I'm trying to figure out if something is even an option with the Zend
> Framework.  We use the DB Table stuff.  I don't see it in the manual, so I
> figured I'd ask you all...
>
> I have:
>
> $select = $table->select()->where( "home_team_id = ?", $home_team_id )
>                                  ->where( "away_team_id = ?", $away_team_id
> );
>
> This translates the where's to "home_team_id = 12 AND away_team_id = 15"...
>
> What I'd like to have is "home_team_id = 12 OR away_team_id = 15".
>
> Is this possible?  Or would I just need to build them all into a single
> where() manually?
>
> --
> -Dan Joseph
>


Try this:

<?php
$select = $table->select()->where( "home_team_id = ?", $home_team_id )
                                 ->orWhere( "away_team_id = ?", $away_team_id );



Andrew

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux