??? You don't show any *LOOP* on the recordset, so of course you will only see one record.
You are using NightmarishStalker code (AKA the misnamed DreamWeaver) but apparently you have modified it. As bad as DrunkWalker code normally is, it would do the loop for you.
But you also say "The above code is repeated using different variables through out the page" and that tells me that your code is horribly inefficient.
Maybe if you showed some sample data from the DB table and some sample output you are trying to achieve we could toss out the DoofusWhacker code and give you something usable.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.