'products',
'where' => "category = $catNum",
'orderBy' => 'RAND()',
'limit' => '1',
));
$selectedProductsRecord = @$selectedProductsRecords[0]; // get first record
assertRecordExists($selectedProductsRecord);
}
// if user did not supply a category, assume they supplied a product num and display that product (also, determine category num for right-side list from that product)
else {
list($selectedProductsRecords, $productsMetaData) = getRecords(array(
'tableName' => 'products',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$selectedProductsRecord = @$selectedProductsRecords[0]; // get first record
assertRecordExists($selectedProductsRecord);
$catNum = $selectedProductsRecord['category'];
}
// get all products in category
list($categoryProductsRecords, $productsMetaData) = getRecords(array(
'tableName' => 'products',
'where' => "category = $catNum",
));
// get category record so we can show its name:
list($categoryRecords, $categoryMetaData) = getRecords(array(
'tableName' => 'category',
'where' => "num = $catNum",
'limit' => '1',
));
$categoryRecord = @$categoryRecords[0]; // get first record
?>
Selected Product
Products in Category: