on the detail page, you have not added a condition to the recordset where clause for the user ID, you need to configure the recordset to filter using the user ID session variable.
at line 298 you have the following code:
mysql_free_result($Products);
that recordset does not exist on this page, delete it.
for the results page, to help troubleshoot, add the following code after the body tag and post back the SQL that it outputs:
<?php echo("SQL: ".$query_limit_WADAproducts); ?>