Where statement with OR doesn't work

3 posts by 2 authors in: Forums > CMS Builder
Last Post: September 2, 2013   (RSS)

Solved with this code

// load recordslist($teamRecords, $teamMetaData) = getRecords(array('tableName' => 'team','where' => whereRecordNumberInUrl(1),'limit' => '1',));$teamRecord = @$teamRecords[0]; // get first record// load recordslist($matchRecords, $matchMetaData) = getRecords(array('tableName' => 'match','where' => "team_home =".intval($squadreRecord['num']), 'orWhere  => "team_away =".intval($squadreRecord['num']), 'orderBy' => 'date_match ASC',));

:-)

Hi Orazio,

Glad you've resolved the problem. Let me know if you have any other questions.

Thanks!

Greg

Greg Thomas







PHP Programmer - interactivetools.com