How do I filter a recordset with login info stored in a cookie?

I've got a log in that stores my user's email and a recordset that populates an order history page. I'd like to filter the following based on the user's email:

From the Order History Page

...$rsOrders->setQuery("SELECT * FROM orders INNER JOIN users ON orders.OrderEmail = <the email address stored in my cookie> ORDER BY orders.OrderDate DESC");
$rsOrders->execute();
?>

From the Log In Page where the email address is entered:

<input name="username" type="text" class="r_corners full_width" id="username" value="<?php echo isset($_COOKIE['userremember'])?$_COOKIE['userremember']:""; ?>">

Help? Is there an example of how this looks somewhere in the forum?

I'd store the userID into the session and then filter with that instead of using the cookie directly.

You can add a parameter to your recordset to filter with the session variable value. If you want help with they syntax, create a new Recordset in the Simple view and choose to filter with a session variable value. Then you can switch to the Advanced view and see how the parameter was created and replicate it in yours.