Query help
3 posts by 2 authors in: Forums > CMS Builder
Last Post: February 26, 2021 (RSS)
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 recordcountry_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 :)
By Djulia - February 25, 2021
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 recordThanks,
Djulia