$query="SELECT * FROM `list`";
$result=mysqli_query($conn,$query);
SELECT `t1`.*, `t2`.*
FROM modx_site_content `t1`
JOIN modx_ms2_products `t2` ON `t1`.`id` = `t2`.`id`
WHERE `t1`.`id` = 541
$res = mysql_query("SELECT model FROM tech WHERE tech_cat='{$cat_id}'");
$models = array();
while ( $row = mysql_fetch_assoc($res) ) {
$models[] = $row['model'];
}
print_r($models);
print_r(array_count_values($models));