Jump to content

Recordset help


4dw

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.