SELECT
`modx_site_content`.id as idd,
`modx_site_content`.pagetitle as title,
`modx_site_content`.alias as alias,
(SELECT value FROM `modx_site_tmplvar_contentvalues` where contentid=idd and tmplvarid='72' limit 1) as image
FROM `modx_site_content`
WHERE (`modx_site_content`.content like '%ключевое-слово-в-описании-категории%') and parent='226' limit 20

(499, 'K PLUS', 'K-PLUS', 'assets/images/risunok2.jpg'),
(523, 'F-U33', 'F-U33', 'assets/images/ph.jpg'),
(2561, 'M30', 'm30', 'assets/images/m333.jpg')

function products(){
$query = "SELECT
`modx_site_content`.id as idd,
`modx_site_content`.pagetitle as title,
`modx_site_content`.alias as alias,
(SELECT value FROM `modx_site_tmplvar_contentvalues` where contentid=idd and tmplvarid='72' limit 1) as image
FROM `modx_site_content`
WHERE (`modx_site_content`.content like '%ключевое-слово-в-описании-категории%') and parent='226' limit 20";
$res = mysql_query($query);
$allval = array();
$row = mysql_fetch_array($res);
while($row = mysql_fetch_array($res)){
echo $row['title'];
}
}
echo products();

function products(){
$total='';
$query = "SELECT
`modx_site_content`.id as idd,
`modx_site_content`.pagetitle as title,
`modx_site_content`.alias as alias,
(SELECT value FROM `modx_site_tmplvar_contentvalues` where contentid=idd and tmplvarid='72' limit 1) as image
FROM `modx_site_content`
WHERE (`modx_site_content`.content like '%слово-по-которому-ищем%') and parent='226' limit 30";
/*Установка кодировки в которой будут идти запросы в бд*/
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET 'utf8'");
mysql_query("SET SESSION collation_connection = 'utf8_general_ci'");
/*Закончили с кодировкой*/
$res = mysql_query($query);
$row = mysql_fetch_array($res);
while($row = mysql_fetch_array($res)){
$total.=$row['title'];
}
return $total;
}
echo products();