Query help

Fri, 26 Feb 2021 12:06:54 -0800

Thanks Djulia that worked :)

Query help

Thu, 25 Feb 2021 01:13:39 -0800

Hi Theclicklab,

Can you try this ?

$geoid = "AU";

// load record from 'banners'
list($bannersRecords, $bannersMetaData) = getRecords(array(
  'tableName'   => 'banners',
  'where'       => "FIND_IN_SET('". mysql_escape($geoid) ."', `country_code`)",
  'loadUploads' => false,
  'allowSearch' => false,
  'limit'       => '1',
));
$bannersRecord = @$bannersRecords[0]; // get first record

Thanks,

Djulia

Query help

Wed, 24 Feb 2021 19:36:55 -0800

Hi there, need some help with a record lookup query:

$geoid = "AU";

// load record from 'banners'
list($bannersRecords, $bannersMetaData) = getRecords(array(
'tableName' => 'banners',
'where' => "`country_code` LIKE '". mysql_escape($geoid) ."'",
'loadUploads' => false,
'allowSearch' => false,
'limit' => '1',
));
$bannersRecord = @$bannersRecords[0]; // get first record

country_code has a list of id's in it separated by comma's like this:

AU,NZ,US

What should I use for 'where' =>

Many thanks :)