Select id and name of users having their birthday this week from database with mysql and php : <p>I have a script that stores user information in a database table. I want to output all users celeberating their birthday in each week of the year (monday - sunday), and I have this already.</p>

<pre><code>&lt;table&gt;
&lt;tr&gt;
    &lt;th&gt;Id&lt;/th&gt;
    &lt;th&gt;Surname&lt;/th&gt;
    &lt;th&gt;Firstname&lt;/th&gt;
&lt;/tr&gt;
&lt;?php
$req = mysql_query( "SELECT * FROM elementary WHERE birthday BETWEEN CURDATE() - INTERVAL 1 WEEK AND CURDATE() + INTERVAL 1 WEEK" );

while($dnn = mysql_fetch_array($req)){
?&gt;
&lt;tr&gt;
&lt;td&gt;&lt;?php echo $dnn["id"] ?&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $dnn["surname"] ?&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $dnn["firstname"] ?&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;?php
}
?&gt;
</code></pre>

<p>Thanks in advance.
 </p>
