Product name not showing on results page with P3

--------------------------------------------------------------------------------

I have upgraded to powerstore 3, my category name doesn't show at the top of my results page anymore. Has the ProductName variable changed?

The results page by default just has a heading of Product List. The way the info on the page loads differs from the previous versions.

If you would like to add in the category name you would need to add in an additional recordset that will select from the category table where the id matches the URL param for category id.

You could then use the bindings from this rs to show the category name, and if there is no category specified you could show the Product List default text. Please post back with any questions that you have about any part of this.

Can you provide me with the correct code to do this Eric?

An example of what the code for the query might look like for you on the page is this:

<?php

$catparam_categories = "-1";

if (isset($row_WADAProducts["CategoryID"])) {

  $catparam_categories = (get_magic_quotes_gpc()) ? $row_WADAProducts["CategoryID"] : addslashes($row_WADAProducts["CategoryID"]);

}

mysql_select_db($database_PowerStoreConnection, $PowerStoreConnection);

$query_categories = sprintf("SELECT * FROM ps3_categories WHERE CategoryID = %s", GetSQLValueString($catparam_categories, "int"));

$categories = mysql_query($query_categories, $PowerStoreConnection) or die(mysql_error());

$row_categories = mysql_fetch_assoc($categories);

$totalRows_categories = mysql_num_rows($categories);

?>

It would need to be just after the products recordset. You can then display the name of the category like this:

<?php echo $row_categories['CategoryName']; ?>