Random chunks

<?php
//forgetting this could case headaches
global $modx;
//handy variables for the sql call
//get the following fields
$fields= (isset($fields))? $fields :"id,name,description,category,snippet";
//from this table
$tbl = (isset($tbl))? $tbl :$modx->getFullTableName("site_htmlsnippets");

//get the id of the category we are calling from the categories table
$catTbl = $modx->getFullTableName("categories");
$catField = "id";
$catDescription = (isset($catDescription))? $catDescription : 'Default_name';
$sql = 'SELECT '.$catField.' FROM '.$catTbl.' WHERE category = \''.$catDescription.'\';';
$result = $modx->dbQuery($sql);
$catArray = array();
for($i=0;$i<@$modx->recordCount($result);$i++) {
array_push($catArray,@$modx->fetchRow($result));
}

$catNo=$catArray[0]['id'];
//this is just in case it can't find the category name it tells us and uses category id of 1
if(!isset($catNo)){
echo "The category: <b>".$catDescription."</b> could not be found. Using a category ID of 1 (Check your category table)";
$catNo=1;
}

//get our fields from the db and save them into a multidimensional array
$sql = 'SELECT '.$fields.' FROM '.$tbl.' WHERE category = '.$catNo.';';
$result = $modx->dbQuery($sql);
$resourceArray = array();
for($i=0;$i<@$modx->recordCount($result);$i++) {
array_push($resourceArray,@$modx->fetchRow($result));
}
//we have the array...so lets use $rand_key to grab a random entry
$rand_key = array_rand($resourceArray);
//and output it 
echo "this is for ".$rand_key." <br />".$resourceArray[$rand_key]['snippet'];
?>