I'm still screwing something up and can't sort out what it is. I think I misunderstand your instructions.
Here's my code with the stuff in bold being what I think your instructions state: This returns no repeated rows for the second recordset.
recordset1 = WADAfigure_lines and the column is series.Series_Id
<?php
$_POST['WADAfigure_lines_series.Series_Id'] = $row_WADAfigure_lines['series.Series_Id'];
$ParamSeriesID_rsFigures = "-1";
if (isset($_POST['WADAfigure_lines_series.Series_Id'])) {
$ParamSeriesID_rsFigures = (get_magic_quotes_gpc()) ? $_POST['WADAfigure_lines_series.Series_Id'] : addslashes($_POST['WADAfigure_lines_series.Series_Id']);
}
mysql_select_db($database_FIGURES, $FIGURES);
$query_rsFigures = sprintf("SELECT Figure_Name, Figure_Thumbnail, series.Series_Id FROM figures INNER JOIN series ON figures.Series_Id = series.Series_Id WHERE series.Series_Id = %s ORDER BY Figure_Name ASC", GetSQLValueString($ParamSeriesID_rsFigures, "int"));
$rsFigures = mysql_query($query_rsFigures, $FIGURES) or die(mysql_error());
$row_rsFigures = mysql_fetch_assoc($rsFigures);
$totalRows_rsFigures = mysql_num_rows($rsFigures);
// RepeatSelectionCounter_1 Begin Loop
$RepeatSelectionCounter_1_IterationsRemaining = $RepeatSelectionCounter_1_Iterations;
while($RepeatSelectionCounter_1_IterationsRemaining--){
if($RepeatSelectionCounterBasedLooping_1 || $row_rsFigures){
?>
<tr>
<td><center><img src="../../images/figure_thumb/<?php echo $row_rsFigures['Figure_Thumbnail']; ?>" alt="" name="Figure_Thumbnail" id="Figure_Thumbnail" width="40" height="40" /></center></td>
<td><?php echo $row_rsFigures['Figure_Name']; ?></td>
<td align="right"><a href="#">Links</a></td>
</tr>
<?php
} // RepeatSelectionCounter_1 Begin Alternate Content
else{
?>
<?php } // RepeatSelectionCounter_1 End Alternate Content
if(!$RepeatSelectionCounterBasedLooping_1 && $RepeatSelectionCounter_1_IterationsRemaining != 0){
if(!$row_rsFigures && $RepeatSelectionCounter_1_Iterations == -1){$RepeatSelectionCounter_1_IterationsRemaining = 0;}
$row_rsFigures = mysql_fetch_assoc($rsFigures);
}
$RepeatSelectionCounter_1++;
} // RepeatSelectionCounter_1 End Loop
?>
</table>
<br />
<?php } while ($row_WADAfigure_lines = mysql_fetch_assoc($WADAfigure_lines)); ?>