HI Ray
The mysql_i query is:
<?php
$rsBirthdays = new WA_MySQLi_RS("rsBirthdays",$connRoSite_i,0);
$rsBirthdays->setQuery("SELECT `members`.`MemID`, `members`.`FirstName`, `members`.`Surname`, `members`.`MemPic`, `members`.`Active`, day(DOB) AS bday, month(DOB) AS bmonth, UNIX_TIMESTAMP(STR_TO_DATE(CONCAT(year(Curdate()), '-',month(DOB),'-',day(DOB),'00:00:00'), '%%Y-%%m-%%d')) AS cbirth FROM members WHERE SiteID= ? AND (DOB is not null ) ORDER BY bmonth, bday, Surname");
$rsBirthdays->bindParam("i", "".$_SESSION['SiteID'] ."", "-1"); //p1
$rsBirthdays->execute();
?>
HTH
Cheers
Chris