When the recordset code is moved inside the repeating region, I get the following error:
Notice: Undefined variable: ProdSizeSelectList in /Applications/MAMP/htdocs/primrose.com/Prod_results.php on line 678
Warning: mysql_free_result() expects parameter 1 to be resource, null given in /Applications/MAMP/htdocs/primrose.com/Prod_results.php on line 678.
Also, when trying to filter the advanced INNER JOIN recordset, I copied an earlier simple recordset that was filtered using the URL Parameter and ID, then clicked advanced, and added the INNER JOIN text back in. I keep getting a syntax error in the WHERE clause on the colname variable default value. I've tried -1, 1 and ID, but still get the error.
File and recordset image attached.