Most likely, the session created at login time is not the same one you are using to filter the recordset by.
to double check this add the following code just before the body tag on the checkout page:
[php<pre><?php var_dump($_SESSION); ?></pre>[/php]
post back the results of this and a screen shoot showing how you have set up the recordset.