it will use the syntax: <?php echo($row_RecordsetName['columnName']); ?>
You will have to look at the query and see if the column name is already available and if not you may even need to add an INNER JOIN to the sql statement to include the category name from the category table.