[SOLVED] Select Dates from Table by Day

[rvdb86]

Hi,

 

I hope this is possible! I have a table with a field the field reg_date which has a DATE format.

 

I want to select all the fields from the table where the m = date("m") and the d = $d where $d is populated by a while loop.

 

Any suggestions?

 

TIA!

[MadTechie]

Huh!

you lost me,

Okay

you want to select all fields (SELECT * FROM table WHERE

the month is what and the day is what ? do you mean a range! you totally lost me!

[samshel]

<?php 
$arrDays = array();

while() { //populate days
$arrDays[] = $something;
}

$sql = "SELECT * FROM table WHERE MONTH(reg_date) ='".$m."' AND DAY(reg_date) IN ('".implode("','", $arrDays).'");

?>

[MadTechie]

Slight bug in your code samshel (easily missed),

Heres the fix..

$sql = "SELECT * FROM table WHERE MONTH(reg_date) ='".$m."' AND DAY(reg_date) IN ('".implode("','", $arrDays)."')";

[rvdb86]

sorry for the late reply, but thanks so much for your help works perfectly!