Problem with dataassist not working after adding new Rs
Ok i had created dataassist pages.
So i need link to have its own url so had changed some settings from this post as discussed:
http://www.webassist.com/forums/posts.php?pid=185247
Now after that things added.
I m stuck at a problem.
I have a product detail page. All seems fine.
Permalink is used & etc.
Now when i add a new RS then problem seems to appear. Must be a problem with codes.
Please can you take a look at it.?
For instance currently all product details are visible on product details page
But as i add another RS for subcat then i don't get an error but all product details are not shown. no error as well.
Before adding new RS:
<?php
$colname_ProductsPerm = "-1";
if (isset($_GET['perm'])) {
$colname_ProductsPerm = $_GET['perm'];
}
$colname_Products = "-1";
if (isset($_GET['ProductID'])) {
$colname_Products = $_GET['ProductID'];
}
mysql_select_db($database_con, $con);
$query_Products = sprintf("SELECT * FROM Products WHERE ProductID = %s OR ProductLink = %s", GetSQLValueString($colname_Products, "int"), GetSQLValueString($colname_ProductsPerm, "text"));
$Products = mysql_query($query_Products, $con) or die(mysql_error());
$row_Products = mysql_fetch_assoc($Products);
$totalRows_Products = mysql_num_rows($Products);
?>
After Adding new Rs:
<?php
$colname_Products = "-1";
if (isset($_GET['perm'])) {
$colname_Products = $_GET['perm'];
}
$colname_Products = "-1";
if (isset($_GET['ProductID'])) {
$colname_Products = $_GET['ProductID'];
}
mysql_select_db($database_con, $con);
$query_Products = sprintf("SELECT * FROM Products WHERE ProductID = %s OR ProductLink = %s", GetSQLValueString($colname_Products, "text"),GetSQLValueString($colname_Products, "text"));
$Products = mysql_query($query_Products, $con) or die(mysql_error());
$row_Products = mysql_fetch_assoc($Products);
$totalRows_Products = mysql_num_rows($Products);
mysql_select_db($database_con, $con);
$query_Recordset1 = "SELECT * FROM subcategories";
$Recordset1 = mysql_query($query_Recordset1, $con) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
before.php and after.php attached.
before.php is only about product details.
without any subcat involved.
after.php is after adding subcat RS . simple RS
after adding New Rs i also replaced from this:
$colname_ProductsPerm = "-1";
if (isset($_GET['perm'])) {
$colname_ProductsPerm = $_GET['perm'];
}
$colname_Products = "-1";
if (isset($_GET['ProductID'])) {
$colname_Products = $_GET['ProductID'];
}
to this:
$colname_Products = "-1";
if (isset($_GET['perm'])) {
$colname_Products = $_GET['perm'];
}
$colname_Products = "-1";
if (isset($_GET['ProductID'])) {
$colname_Products = $_GET['ProductID'];
}
Yet no result showing up.