query from a category its products name, price, image, description and attributes

[cmsdeployed]

<?php
 // retrieve products from database
 global $db;
$q1 = $db->Execute("select * from products");
$q1_items = array();
$q2_items = array();

while (!$q1->EOF){
$q1_items[] = $q1->fields;
$q1->MoveNext();
}
foreach ($q1_items as $item => $items) {
echo '<p><a href="index.php?main_page=product_info&products_id='. $items['products_id'] .'"><img src="images/'. $items['products_image'].'" alt="'. $items['products_name'].'" title="'. $items['products_name'].'" /></a>';
    echo ''.$items['products_price']. ''; ?>

<?php }
?>

The issue I am having is it doesn't not pull the product name and I would like to be able to query each product_description from TABLE_PRODUCTS_DESCRIPTION and Products_attributes.