Tabular Display of multiple Records filtered by UserID

On my user_Profile.php (parents), I need to display all of their sub-user accounts (kids names). I would like to do this like an expanding table with a horizontal row for each sub-user record (according to the number of sub-users name & nickname). I also need to allow user’s links/buttons, from their profile page, to add/update/remove sub accounts and to make purchases for each sub-user independently. Using WebAssist, separate registration and profile pages have already been created can be linked to. I have separate db tables, one for users and one for sub-users, using MySQL InnoDB.

I have read the guides but I am not sure if I will get the results that I want. Which WebAsssit Tool should I use? DataAssist – Repeat Selection?

Run DataAssist for the kids names database table. Specify the user_Profile.php page as the results page and don't create a search page.

Then after the wizard runs go to the profile page and add code so that the kids names table is filtered by the same session variable you are using at login to filter the parents recordset on that page.

You will have to update the insert page to store the session variable for the associated parent when inserting child records as well.

Sorry to be a bug, but do I run DataAssist Wizard, DataAssist Search Wizard, DataAssist Search server behavior, or DataAssist Repeating Table? I started, but then realized that have not used any at this point and I am not sure how to determine which I need.

DataAssist wizard

Thanks Ray, I have used the DataAssist Wizard and created the pages (less the search page). Up to this point I had created all the pages using SecurityAssist and with your kind assistance was passing the parents userID via the login $_SESSION to the kids_registration page.

With DataAssist, the new pages pulls from the db tbl a row for each kid sub-account under the main user account and places their information into a row in the table. This was the resault that I wanted. View and update pages work using the DataAssist created pages which pass the individual kidSID through the url. This does not seem to provide the level of security that I need for handling the user/member accounts. I would prefer to send each of the kids account information pulled into the table to the next page veiw/update/delete using the $_SESSION. Is there a way to put their information into a session variable/value (I am still not 100% clear on how to set these up) depending on which kid the parent wants to view/edit/delete? Below is the code for a typical link. Is it just a matter of editing this link code to set that particular kids values?

<td><a href="member_Profile.php?kidSID=<?php echo(rawurlencode($row_WADAtbl_members['kidSID'])); ?>" title="View"><img border="0" name="View<?php echo(rawurlencode($row_WADAtbl_members['kidSID'])); ?>" id="View<?php echo(rawurlencode($row_WADAtbl_members['kidSID'])); ?>" alt="View" src="../../WA_DataAssist/images/Pacifica/Refined_zoom.gif" /></a></td>

This would work in conjunction with the login from SecurityAsssit. Any session variables stored during login would be available to filter recordsets or insert records into the database in dataassist.

I don't think you would edit the link. I think you would possibly edit the Recordset or the Insert server behaviors so that they use the Session directly to filter out or insert record values.

Ray, I'm sure that you are right, but I am a little lost. On the parents_Profile page c/w the new kid's table, I have the kids recordset filtered by the parent's userSId=Session Variable userSID. In my mind I was going to link from the parents_Profile to to members_Profile (created before with SecurityAssist) page. Perhaps you are thinking changing settings on using the member_Update page to acomplish the same resaults? I do not want people to see the member id in the url (so that they can not simply edit someonelses kid's profile.

You have mentioned setting and filtering the recordsets. I get confused about, "I do what to which page?" Please clairify with each step separatly so that I can follow. Thank you.

I don't have a bunch of steps. Just use a session variable instead of or on top of the url parameter to filter your recordset.

Thank you Ray for your assistance with seting the $_SESSION value for the KidSID. I have been trying to figure that out for two weeks. I was able to set and pass the value on to the kids profile page. I will have to setup the navigation buttons but the primary function works fine.

With multipule sub-members (kid accounts) I found that the kidID value increments depending with the number of records viewd/retrived in the table based on the $row_WADAtbl_members['kidSID'])); value. Without requiring extra coding at this time, I was able to reduce the ($maxRows_WADAtbl_tablename = 1;) maximum number of records viewed to 1. This allows for the variable to be set correctly for each record viewed and proceed to update/view/delete. The navigation buttons allow you view the remainder of the records.