Как получить значение из таблицы в переменную, зная id строки?

$cname = ?

$result = mysql_query($sql) OR die($sql . " " . mysql_error());
$arr = mysql_fetch_assoc($result);
echo $arr['name'], '<br />??????<br />PROFIT!!';//OR $cname = $arr['name'];

$result = mysql_query($sql,$data) OR die($sql . " " . mysql_error());
$arr = mysql_fetch_assoc($result);
echo $arr['name'], '<br />??????<br />PROFIT!!';//OR $cname = $arr['name'];

public $dbtype = 'mysqli';
public $host = 'localhost';
public $user = 'user';
public $password = 'pass';
public $db = 'joomla_db';
public $dbprefix = 'joom_';

<?php
        
defined ('_JEXEC') or die('Restricted access');
$par = JComponentHelper::getParams( 'com_djclassifieds' );
$app = JFactory::getApplication();
$item = $this->item; // это в начале страницы, врятли оно сюда относится, далее:
 
$sql = ("SELECT name FROM fn82l_djcf_categories WHERE id = $item->cat_id"); 
$result = mysql_query($sql) OR die($sql . " " . mysql_error());
$arr = mysql_fetch_assoc($result);
echo $arr['name'], '<br />??????<br />PROFIT!!';//OR $cname = $arr['name'];

$mysql_database="**********"; 
$mysql_username="**********"; 
$mysql_password="**********"; 
$mysql_host="localhost"; 
 
$db = mysql_connect($mysql_host, $mysql_username, $mysql_password); 
mysql_select_db($mysql_database,$db); 
 
$sql = ("SELECT name FROM fn82l_djcf_categories WHERE id = $item->cat_id"); 
 
$result = mysql_query($sql);
$arr = mysql_fetch_assoc($result);
echo $arr['name'];//OR $cname = $arr['name'];