使用PHP / MySQL显示一周内发生的生日

Question

I have a database of users with birthdays, would it be possible to display whose birthday it is today and any birthdays coming up within a week of the current date. I have this but it's not working.

<?php
  $retrieveBirthday = mysql_query( "SELECT * FROM memberData WHERE mBirthday BETWEEN CURDATE() - INTERVAL 1 WEEK AND CURDATE() + INTERVAL 1 WEEK" );
    echo $retrieveBirthday;
?>

Where am I going wrong here? I know it should be mysqli but security isn't an issue here.

Answer 1

It looks like you just forgot to wrap the query inside mysql_result() or mysql_fetch_array():

<?php
  $query = mysql_query( "SELECT * FROM memberData WHERE mBirthday BETWEEN CURDATE() - INTERVAL 1 WEEK AND CURDATE() + INTERVAL 1 WEEK" );
  while ($rows = mysql_fetch_array($query, MYSQL_NUM)) {
    $retrieveBirthdays = $rows;
  }
  foreach ($retrieveBirthdays as $retrieveBirthday) {
    echo $retrieveBirthday;
  }
?>