FuelPHP Forums

coax

hi,
I want to do the following query in fuelphp but don't find in the doc the way to do the last part of my query.
my sql query is:
SELECT *
FROM `sgsses`
WHERE `categorie` = 'manuel'
AND (
`langue` = 'fr'
OR `langue` = 'it'
)
my fuelphp query is : $data = Model_Sgss::find('all', array('where' => array(array('categorie', '=', 'manuel'), array('langue', '=', 'fr'))));
I don' find the way to do '`langue` = 'fr' OR `langue` = 'it', can someone help me.
thank you

WanWizard

I don't know if and how you could do that when using array notation. When using chaining, you would use

$data['sgsss'] = Model_Sgss::query()
    ->where('categorie', '=', 'manuel')
    ->where_open()
        ->where('langue', '=', 'fr')
        ->or_where('langue', '=', 'it')
    ->where_close()
    ->get();

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.

Howdy, Stranger!

Categories

In this Discussion