Re: [PHP] Zend DB Table - WHERE as OR?
On Fri, Apr 9, 2010 at 3:15 PM, Dan Joseph 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: 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
Re: [PHP] Zend DB Table - WHERE as OR?
On Fri, Apr 9, 2010 at 3:25 PM, Andrew Ballard wrote: > Try this: > > $select = $table->select()->where( "home_team_id = ?", $home_team_id ) > ->orWhere( "away_team_id = ?", > $away_team_id ); > > Perfect...thank you! -- -Dan Joseph www.canishosting.com - Unlimited Hosting Plans start @ $3.95/month. Promo Code "NEWTHINGS" for 10% off initial order http://www.facebook.com/canishosting http://www.facebook.com/originalpoetry
[PHP] Zend DB Table - WHERE as OR?
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 www.canishosting.com - Unlimited Hosting Plans start @ $3.95/month. Promo Code "NEWTHINGS" for 10% off initial order http://www.facebook.com/canishosting http://www.facebook.com/originalpoetry