Be a Buddy
Through Red Door's Buddy System, you can show your compassion for rescued animals by becoming an online buddy to an animal. A donation of $28 or more helps provide a needy animal with food, shelter and veterinary care prior to being placed in a new and loving home.
Consider giving a Buddy System gift for birthdays, anniversaries, or holidays! We can customize every Buddy posting with a special message from you.
Please click here for the Buddy Sponsorship Form
require("database_inc.php"); $sql = "SELECT sponsorships.animal_id, image_name, animal_name, last_sponsored, sponsor, sponsor_id, end_date, sponsor_copy, sponsored_date FROM sponsorships LEFT JOIN Animals USING(animal_id) WHERE animal_active = 1 AND active = 1 ORDER BY sponsored_date DESC"; if ( $result = mysqli_query($link, $sql) ) { $rows = mysqli_num_rows($result); if ( $rows > 0 ) { while ( $row = mysqli_fetch_array($result) ) { $image = "http://www.reddoorshelter.org/animal_photos/" . $row["image_name"]; $size = getimagesize($image); $height = $size[1]; $width = $size[0]; echo "
";
if ( $height > $width ) {
echo "" . $row["animal_name"] . ""; echo "Buddy: " . $row["sponsor"] . ""; $SponsorDate = explode("-", $row[sponsored_date]); echo "A Buddy since: " . date("m/d/Y", mktime(0, 0, 0, $SponsorDate[1], $SponsorDate[2], $SponsorDate[0])) . " "; echo "Message: " . $row["sponsor_copy"]; echo " |
"; } mysqli_free_result($result); } } else { die("No current buddies"); } ?>