[solved] Replacement for "while" loop

Code: Select all

//Find the customers whose birthday is today
$findCustomers = $this->db->query("SELECT * FROM customer WHERE substr(birth_date,6) = '" . $todayDate . "'");
while($row = mysql_fetch_array($findCustomers)){
   $birthDate = $row['birth_date'];
   $birthEmail = $row['bday_email'];
   $age = $thisYear - (substr($birthDate,0,4));

Code: Select all

$findCustomers = $this->db->query("SELECT * FROM customer WHERE substr(birth_date,6) = '" . $todayDate . "'");
foreach ($findCustomers->rows as $row) {
   $birthDate = $row['birth_date'];
   $birthEmail = $row['bday_email'];
   $age = $thisYear - (substr($birthDate,0,4));