I ran DataAssist and created the usual pages. Insert, Delete, Update, Search, Results.
I need the search page to only return results for jobs inserted by the user who is logged in and doing the search, as opposed to bringing up all jobs listed.
So, per your instruction, I added a hidden form field to the insert.php that inserts the session variable MM_UserID into the member_id field of the jobs table.
The property inspector shows: hiddenUserID Value <?php echo $_SESSION['MM_UserID']; ?>
So far, so good, I insert a new job and the job listing table shows the member_ID correctly.
Now, I am trying to edit the results page record set (WADAjobs) with WHERE member_id = 'colname' and I'm defining a variable colname as integer, default value -1, $_SESSION['MM_UserID']
When I do this, I get the error message and no update is done to the page. So when a user logs in to edit their job listing and does a search, they are getting access to all jobs, not just their own.
Any help you can give Ray is appreciated. I know the support guys are swamped and my tickets often don't get answered for several days.
