MySQL Temp Table

Hi Experts,

The following code works but is incorrect because multiple users will over write each other.  I have been playing with moving it to a Temp table but that isn't working because the temp table is gone when I move to a new page.  The process I am trying to do is as follows, how should I be doing this? Session variables?  query string? temp table? Other?  I know what I am doing is wrong.  Thanks!

The user selects a group of loans by date/audit type.
A list of the selected loans are listed with a href link that open the profile screen
At the top of the page there is a button to go to the next or previous loan in the subset (that is why I have the table in the first place to store the subset)

<?php
error_reporting(E_ALL);

        $userIDKey=$userListRow['id'];
        include 'include/userConnect.php';

        $beginDate=mysql_real_escape_string($_POST['begin']);
        $endDate=mysql_real_escape_string($_POST['end']);
        $auditTypeKey=mysql_real_escape_string($_POST['type']);
        $branchKey=mysql_real_escape_string($_POST['branch']);

            $d = "DROP Table if exists auditMgmt";
             mysql_query($d) or die(mysql_error());
            $c = "CREATE TABLE auditMgmt SELECT loan.loanKey,
                loan.loanNumber,
                borrower.lastName,
                borrower.firstName,
                audit.auditID,
                loan.branchKey,
                audit.trackingDate
                FROM loan
                JOIN audit USING (loanKey)
                LEFT JOIN borrower USING (loanKey)
                WHERE loan.branchKey='$branchKey'
                AND audit.activeStatus='1'
                AND auditTypeKey='$auditTypeKey'
                AND borrower.type='1'
                AND borrower.active='1'
                AND trackingDate BETWEEN '$beginDate' AND '$endDate'
                ORDER BY audit.auditID";
           
            mysql_query($c) or die(mysql_error());
                                             ?>

Select all Open in new window