joomla DB query code

//DB
$db =& JFactory::getDBO();
$queryz = "SELECT * FROM jos_content WHERE catid = '".$cat_id."' ORDER BY id DESC".$tt;

//query per parametri
$db->setQuery( $queryz, 0, $params->get('items',5) );
//query totale
$db->setQuery( $queryz, 0 );

$rows = $db->loadObjectList();

foreach($rows as $row)
{
$idd=$row->id;
$name1 = $row->title;
$text1= $row->introtext;
$fulltext1= $row->fulltext;
echo "<a href='http://joomla.overgrid.com/index.php?option=com_content&view=article&id=".$idd."'>".$name1."</a><br>";
}

---

//DB
$db =& JFactory::getDBO();
$queryz = "SELECT * FROM jos_content WHERE catid = '34'";
$db->setQuery( $queryz, 0 );

$rows = $db->loadObjectList();


foreach($rows as $row)
{
$id=$row->id;
$title=$row->title;
$alias=$row->alias;
$title_alias=$row->title_alias;
$introtext=$row->introtext;
$fulltext=$row->fulltext;
$state=$row->state;
$sectionid=$row->sectionid;
$mask=$row->mask;
$catid=$row->catid;
$created=$row->created;
$created_by=$row->created_by;
$created_by_alias=$row->created_by_alias;
$modified=$row->modified;
$modified_by=$row->modified_by;
$checked_out=$row->checked_out;
$checked_out_time=$row->checked_out_time;
$publish_up=$row->publish_up;
$publish_down=$row->publish_down;
$images=$row->images;
$urls=$row->urls;
$attribs=$row->attribs;
$version=$row->version;
$parentid=$row->parentid;
$ordering=$row->ordering;
$metakey=$row->metakey;
$metadesc=$row->metadesc;
$access=$row->access;
$hits=$row->hits;
$metadata=$row->metadata;


echo "<div style='width:100%; border: solid 1px green; margin-bottom: 10px;'>$title</div>";
}