the code for the products is duplicated on your results page. delete the code at lines 88 - 97:
$colname_WADAproducts = "-1";
if (isset($_SESSION['SecurityAssist_UserID'])) {
$colname_WADAproducts = (get_magic_quotes_gpc()) ? $_SESSION['SecurityAssist_UserID'] : addslashes($_SESSION['SecurityAssist_UserID']);
}
mysql_select_db($database_Connection1, $Connection1);
$query_WADAproducts = sprintf("SELECT * FROM products WHERE productUser = %s ORDER BY ProductName ASC", GetSQLValueString($colname_WADAproducts));
$query_limit_WADAproducts = sprintf("%s LIMIT %d, %d", $query_WADAproducts, $startRow_WADAproducts, $maxRows_WADAproducts);
$WADAproducts = mysql_query($query_limit_WADAproducts, $Connection1) or die(mysql_error()."<br />".$query_limit_WADAproducts);
$row_WADAproducts = mysql_fetch_assoc($WADAproducts);
i think the error you are getting is caused by line 116:
$query_WADAproducts = sprintf("SELECT * FROM products WHERE productUser = %s ORDER BY ProductName ASC", GetSQLValueString($colname_WADAproducts, "-1"));
this should be changed to:
$query_WADAproducts = sprintf("SELECT * FROM products WHERE productUser = %s ORDER BY ProductName ASC", GetSQLValueString($colname_WADAproducts, "int"));
on the detail page line 101:
$query_WADAuploads = sprintf("SELECT UploadID, UploadedFileName, Comments, Status, AniSnapImg, UploadThumb, AniSnapCode FROM uploads WHERE UploadID = %s OR ( -1= %s AND UploadID= %s)", GetSQLValueString($ParamUploadID_WADAuploads,"int"),GetSQLValueString($ParamUploadID2_WADAuploads)
should be:
$query_WADAuploads = sprintf("SELECT UploadID, UploadedFileName, Comments, Status, AniSnapImg, UploadThumb, AniSnapCode FROM uploads WHERE UploadID = %s OR ( -1= %s AND UploadID= %s)", GetSQLValueString($ParamUploadID_WADAuploads, "int"),GetSQLValueString($ParamUploadID2_WADAuploads, "int"),GetSQLValueString($ParamSessionUploadID_WADAuploads, "int"));