products not displaying in results page

Hey Jason

Am just implementing mod rewrite on a site and since doing that (which works fine) the data from the database is no longer being shown on the page.

If you go here: http://www.hairmekanix.co.uk/sections.php and then click on any of the categories, for example, 'electricals' you will see the following text "Don't Panic! Products are coming to this section shortly!!" when in fact there should be 2 product items showing.

I have attached the file and would be really grateful if you could take a look please?

Many thanks

you only updated the ProductCategories recordset to use the permalinks, you dint update the Products recordset.

Aha gotcha! Many thanks. Thats working great and was something that I needed to be able to get some breadcrumbs working on the product detail page.

On that page, however, regardless of which section the product is in, the first record of the table (shampoos) displays as the section rather than the right one and as a result the link back to the category sections is also set to 'shampoos'.

If you look at http://www.hairmekanix.co.uk/product/hairdryer , the breadcrumb should be 'Electricals' rather than shampoo.

Have attached the page.

In the ProductsCategory recordset I have toggle the $colname_ProductsCategory = between 1 and -1. With -1 it doesnt show the category at all (its just blank between >> >> ) and with 1 it shows the category albeit incorrectly.

TIA

Jamie

again, the ProductsCategory recordset only uses the product ID filter.


since you are using the permalink address, you need to add the permalink filter to _all_ of the recordsets on the page.

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);
?>

try echoing the SQL to the page. add this code in the body:

<?php echo $query_ProductsCategory; ?>

then copy the SQL and run it directly on the database. Does it return the desired result?

OK, I get

SELECT products.*, productcategories.* FROM products INNER JOIN productcategories ON products.ProductCategoryID = productcategories.CategoryID WHERE ProductID = '-1' OR CatPermalink = 'brush'

have run it on 2 tables (products and productcategories) and nothing shows in the results in either of them.

See PM.

See PM

See PM