Filtering recordset with others recordsets row value
Hi, i am trying to filter a recordsets with another recordsets row value
mysql_select_db($database_c_conn, $c_conn);
$query_R1_RS = "SELECT * FROM R1 ORDER BY ID DESC";
$R1_RS = mysql_query($query_R1_RS, $c_conn) or die(mysql_error());
$row_R1_RS = mysql_fetch_assoc($R1_RS);
$totalRows_R1_RS = mysql_num_rows($R1_RS);
mysql_select_db($database_c_conn, $c_conn);
$query_Member_RS = "SELECT * FROM record_list WHERE `member Name` = '$row_R1_RS['member_name'] '";
$Member_RS = mysql_query($query_Member_RS, $c_conn) or die(mysql_error());
$row_Member_RS = mysql_fetch_assoc($Member_RS);
$totalRows_Member_RS = mysql_num_rows($Member_RS);
it don't work, uncorrect syntax :(
can some 1 show me the right syntax ?
Thanks