Recordset help

[4dw]

Hi

 

I need to list different names from a database, I'm creating a different recordset and filtering the id for each name, so I'll end up with about 20 recordsets.

 

Can/how can I create 1 recordset then choose the id from with the webpage?

 

At the moment it's starting to look like this:

 

mysql_select_db($database_ConsultMembers, $ConsultMembers);

$query_Recordset2 = "SELECT * FROM members WHERE id = 5";

$Recordset2 = mysql_query($query_Recordset2, $ConsultMembers) or die(mysql_error());

$row_Recordset2 = mysql_fetch_assoc($Recordset2);

$totalRows_Recordset2 = mysql_num_rows($Recordset2);

 

mysql_select_db($database_ConsultMembers, $ConsultMembers);

$query_Recordset3 = "SELECT * FROM members WHERE id = 24";

$Recordset3 = mysql_query($query_Recordset3, $ConsultMembers) or die(mysql_error());

$row_Recordset3 = mysql_fetch_assoc($Recordset3);

$totalRows_Recordset3 = mysql_num_rows($Recordset3);

 

Thanks!