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.
Change the parameter code back... that would definitely break it. If you still have issues, please post the url and ftp information in the private area and I'll take a look. 
