4dw Posted April 10, 2007 Share Posted April 10, 2007 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! Link to comment https://forums.phpfreaks.com/topic/46404-recordset-help/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.