https://interactivetools.com/forum/forum-search.php?k=user%3Aferrisj Wed, 13 May 2026 14:53:07 -0700 en-us https://interactivetools.com/forum/forum-posts.php?postNum=2200719#post2200719 ]]> Wed, 16 Dec 2009 18:25:02 -0800 forum-posts.php?postNum=2200719#post2200719 https://interactivetools.com/forum/forum-posts.php?postNum=2200710#post2200710
I have a table of product_categories (fields: name, content, photo)

I have my main products table that has a "list" field that pulls in the category from product_categories table. I want my products_detail.php page to list all products under a category that is specified in the url from the previous category list page. (ie product_details.php?ipphones-2)


require_once "/home/......./admin/lib/viewer_functions.php";

list($product_categoryRecords, $product_categoryMetaData) = getRecords(array(
'tableName' => 'product_category',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$product_categoryRecord = @$product_categoryRecords[0]; // get first record

// show error message if no matching record is found
if (!$product_categoryRecord) {
header("HTTP/1.0 404 Not Found");
print "Record not found!";
exit;
}

list($productsRecords, $productsMetaData) = getRecords(array(
'tableName' => 'products',
'where' => "category LIKE '%\t" . mysql_escape($product_categoryRecord['num']) . "\t%'",
));

?>
]]> Wed, 16 Dec 2009 16:10:14 -0800 forum-posts.php?postNum=2200710#post2200710