sorry Jason but I have added it to the recordset:
<?php
$colname_CategoryPerm = "-1";
if (isset($_GET['perm'])) {
$colname_CategoryPerm = $_GET['perm'];
}
$colname_ProductsCategory = "-1";
if (isset($_GET['id'])) {
$colname_ProductsCategory = $_GET['id'];
}
mysql_select_db($database_PowerCMSConnection, $PowerCMSConnection);
$query_ProductsCategory = sprintf("SELECT products.*, productcategories.* FROM products INNER JOIN productcategories ON products.ProductCategoryID = productcategories.CategoryID WHERE ProductID = %s OR CatPermalink = %s", GetSQLValueString($colname_ProductsCategory, "text"),GetSQLValueString($colname_CategoryPerm, "text"));
$ProductsCategory = mysql_query($query_ProductsCategory, $PowerCMSConnection) or die(mysql_error());
$row_ProductsCategory = mysql_fetch_assoc($ProductsCategory);
$totalRows_ProductsCategory = mysql_num_rows($ProductsCategory);
?>