Are you sure the member name that is being displayed from R1_RS exists in the member table?
Here is something to try, add the following code just after the <body> tag:
[php]<?php echo($query_member_RS); ?>
this will write the sql being used to the screen. copy this SQL, then start a new recordset. In advanced view, past this SQL then pres the test button.
Please post back the results of the test and the SQL.
also double check that the value being searched for actually exists in the members table.
Hi Jason,
I tried it again today, and it work!!! I don't know what is going on, it din't work when i tried yesterday..maybe some kind of bugs i think.. Anyway, Thanks :)