работа с MySQL из под Joomla - Joomla 1.5: Общие вопросы

<?php
  $db = mysql_connect("bd.mysql","user","pass") or die("Could not connect : " . mysql_error());
  mysql_select_db("my_db" ,$db);
  $sql = mysql_query("SELECT * FROM catalog WHERE `iid`= \"$dev\"");
  while ($row = mysql_fetch_array($sql))
  {
  $vendor=$row['vendor'];
  $model=$row['model'];
  $discript=$row['discript'];
  $price=$row['price'];
  echo ($price);
  }
  mysql_close($db);
?>

$db 	= JFactory::getDBO();
$query = 'SELECT * FROM catalog WHERE iid= '.$dev.'';
$db->setQuery($query);
$rows = $db->loadObjectList();
foreach ( $rows as $row )
{
echo $row->vendor;
echo $row->model;
echo $row->discript;
echo $row->price;
}

<?php
$db =& JFactory::getDBO();
$query = 'SELECT * FROM catalog WHERE iid=`2`';
$db->setQuery($query);
$rows = $db->loadObjectList();
foreach ( $rows as $row )
{
echo $row->vendor;
echo $row->model;
echo $row->discript;
echo $row->price;
}
?>

$query = 'SELECT * FROM catalog WHERE iid=2';

$db =& JFactory::getDBO();

$query = 'SELECT * FROM catalog WHERE iid=`2`';

$query = "SELECT * FROM 'jos_catalog' WHERE iid= 2";

Notice: Undefined property: text in /home/ino.ru/docs/plugins/content/rd_addphp.php on line 64

Notice: Undefined property: id in /home/ino.ru/docs/components/com_content/views/article/view.html.php on line 113

Notice: Undefined property: title in /home/ino.ru/docs/components/com_content/views/article/view.html.php on line 119

Notice: Undefined property: metadesc in /home/ino.ru/docs/components/com_content/views/article/view.html.php on line 123

Notice: Undefined property: metakey in /home/ino.ru/docs/components/com_content/views/article/view.html.php on line 126

Notice: Undefined property: title in /home/ino.ru/docs/components/com_content/views/article/view.html.php on line 131

Notice: Undefined property: author in /home/ino.ru/docs/components/com_content/views/article/view.html.php on line 134

Notice: Undefined property: metadata in /home/ino.ru/docs/components/com_content/views/article/view.html.php on line 137

Notice: Undefined property: id in /home/ino.ru/docs/plugins/content/vote.php on line 23

Notice: Undefined property: title in /home/ino.ru/docs/components/com_content/views/article/tmpl/default.php on line 6

CREATE TABLE IF NOT EXISTS `jos_catalog` (
  `iid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'индекс',
  `type` varchar(11) NOT NULL COMMENT 'тип оборудования',
  `vendor` varchar(20) NOT NULL COMMENT 'производитель',
  `model` varchar(50) NOT NULL COMMENT 'название модели',
  `discript` varchar(50) NOT NULL COMMENT 'путь к файлу описания',
  `price` int(11) NOT NULL COMMENT 'цена',
  `quant` int(5) NOT NULL COMMENT 'количество',
  PRIMARY KEY (`iid`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3 ;

<?php
$db =& JFactory::getDBO();
//$query = 'SELECT * FROM #__catalog WHERE iid=`2`';
$db->setQuery("SELECT * FROM jos_catalog WHERE iid = 2");
$rows = $db->loadObjectList();
foreach ( $rows as $row )
{
//echo $row->vendor;
//echo $row->model;
//echo $row->discript;
echo $row->price;
echo "help";
}
?>

{rdaddphp file=/scripts/catalog_mysqlconn.php}

$update="update tree set name='процессорыкк' where child='4'";
$db->setQuery($update);
$db->loadObjectList();
echo '<pre>';
print_r($db);
echo '</pre>';

$update="update `tree` set `name`='процессорыкк' where `child`='4'";
$db->setQuery($update);
$db->query();

$update="update tree set name='процесс' where child='4'";
$db->setQuery($update);
$db->loadObjectList();