Локализация sql запроса - JoomShopping

    <?php foreach($this->categories as $k=>$category){
		$link = mysql_connect('localhost', 'root', '') or die('Ошибка: Не удалось подключится.'.mysql_error($link));
		mysql_select_db('im', $link) or die('Не подключается. '.mysql_error($link));
		$sql ="SELECT time FROM #_jshopping_products_reviews LIMIT 2";
		$result = mysql_query($sql, $link) or die('Ошибка! '.mysql_error($link));
		$result_array = array();
			while ($result_array = mysql_fetch_assoc($result)){
				echo $result_array['time'];
			}
	}?>

	<?php
		$link = mysql_connect('localhost', 'root', '') or die('Ошибка: Не удалось подключится.'.mysql_error($link));
		mysql_select_db('im', $link) or die('Не подключается. '.mysql_error($link));
		$sql ="SELECT * FROM #_jshopping_products_reviews WHERE publish_type='$nomer'";
		$result = mysql_query($sql, $link) or die('Ошибка! '.mysql_error($link));
		$result_array = array();
		while ($result_array[] = mysql_fetch_assoc($result));
		foreach ($result_array as $string) {?>
		<div>
			<div><?php print $string['time'];?></div>
			<div><?php print $string['user_email']; ?></div>
			<div><?php print $string['review'];?></div>
		</div>
	    <?php }?>

$db = JFactory::getDbo();
foreach($this->categories as $k => $category)
{
	$query = $db->getQuery(true)
		->select($db->quoteName("time"))
		->from($db->quoteName("#__jshopping_products_reviews"))
		->order($db->quoteName("review_id")." ASC LIMIT 2");
	$db->setQuery($query);
	$result_array = $db->loadRowList("time");
	print_r($result_array);
}

$db = JFactory::getDbo();
	$query = $db->getQuery(true)
		->select("*")
		->from($db->quoteName("#__jshopping_products_reviews"))
		->where($db->quoteName("publish_type")." = ".$db->quote($nomer));
	$db->setQuery($query);
	$result_array = $db->loadObjectList();
	foreach ($result_array as $string){?>
	<div>
		<div><?php print $string->time; ?></div>
		<div><?php print $string->user_email; ?></div>
		<div><?php print $string->review; ?></div>
	</div>
	<?php } ?>

			<div class="count_prod_cat"><?php 
				$db=&JFactory::getDBO();
				$query="SELECT COUNT(*) FROM teyzk_jshopping_products WHERE prod_category='$category->category_id'";
				$db->setQuery($query);
				$count_prod=$db->loadResult();
				echo $count_prod;
			?> товаров</div>

    <?php foreach($this->categories as $k=>$category){
	$db = JFactory::getDbo();
	$query="SELECT * FROM #_jshopping_products WHERE prod_category='$category->category_id'";
	$db->setQuery($query);
	$result_array = $db->loadObjectList();
	foreach (array_slice($result_array, 0 ,2) as $string){?> // 0 - сортировка (похоже), 2 - количество выводимых записей
	<div>
		<div><?php print $string->date_modify; ?></div>
		<div><?php print $string->name; ?></div>            //Не работает
		<div><?php print $string->name_en-GB; ?></div>  //Не работает
		<div><?php print $string->name_en; ?></div>       //Не работает
	</div>
	<?php } 
	
echo "<br>"; //отделение
}?>

$lang = JSFactory::getLang();
echo $lang->get("name");

$lang = JSFactory::getLang();
$query="SELECT *, ".$lang->get("name")." as name FROM #_jshopping_products WHERE prod_category='$category->category_id'";
...
<div><?php print $string->name; ?></div>

$query="SELECT image, `".$lang->get('name')."` as name, `".$lang->get('alias')."` as alias FROM #__jshopping_products WHERE prod_category='$category->category_id'";

<?php
jimport..
defined..
class JshoppingControllerSeacher extends JControllerLegacy{

        function okey(){

        $db = new mysqli('localhost', 'root', '', 'poisk'); //так работает 

        $db = mysqli_connect('localhost', 'user', 'password', 'world'); // так тоже работает

        $db = JFactory::getDbo(); // а вот так не работает!

        $queryString = $_POST['queryString'];
        $query = $db->query("SELECT * FROM teyzk_jshopping_products WHERE image LIKE '%" . $queryString . "%' ORDER BY date_modify LIMIT 8");
        while ($result = $query ->fetch_object()) {
                echo $result->image;       			
                echo $result->hits;
	}
}
?>

SELECT one, two, three FROM tablica WHERE ".$lang->get("name")." as name LIKE и тд.

...WHERE ".$lang->get("name")." as name...

SELECT `".$lang->get("name")."` as name ... WHERE name ...

    $sql = "SELECT `".$lang->get('short_description')."` AS short_description FROM teyzk_jshopping_products WHERE short_description LIKE '%" . $word . "%'";

echo $sql;

SELECT image, `short_description_en-GB` AS short_description FROM teyzk_jshopping_products WHERE short_description LIKE '%описание%'

<?php
jimport..
defined..
class JshoppingControllerSeacher extends JControllerLegacy{
function okey(){
$sql = "SELECT image FROM teyzk_jshopping_products WHERE `short_description_en-GB` LIKE '%" . $word . "%'";
$row = $db->select_list($sql);
    if(count($row)) { // если найдено
        foreach($row as $r) {
            echo $r['image'];
        }
    } else { // если не найдено
	$str = translit($word); //вызов translit
	echo $str;
?>

$db->setQuery($query, $offset, $limit);