just before the if statement, echo the values:
<?php echo $row_SponsorsFooter['SponsorLive'] ."|". $row_SponsorsFooter['SponsorCategoryID'] ."|". $row_SponsorsSponsorsFooter['SponsorCategoryID']; ?>
what does that return?
my bet is that it wont return the values you expect, not that you are using 2 different recordsets, this probably wont give the desired results unless the SponsorsSponsorsFooter is nested in the first one.
http://www.webassist.com/tutorials/Display-nested-recordsets