Select with date difference

[NZ_Kiwis]

I have this code

$today = date("j/n/Y");
include 'processor/db.php';

$result = mysql_query ("SELECT * From r_Groups WHERE EndDate < '$today' and StartDate >= '$today'");

The StartDate and EndDate around in the same format as $today 5/5/2007 for example

What I want to do is echo the GroupName which is past the last end date but has not yet pasted the next StartDate... this does not echo anything... what's wrong or how can i do this?

[Kudose]

I don't think MySQL can make comparisons like that ... You should use DATE_FORMAT in the SQL.

i.e.

SELECT * FROM r_Groups WHERE EndDate < DATE_FORMAT($today, '%m%d%Y') AND StartDate >= DATE_FORMAT($today, '%m%d%Y')

untested

[NZ_Kiwis]

Okay... I get this error now

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/sportsf/public_html/admin/results/date.php on line 10

//DD/MM/YYYY
$today = date("j/n/Y");
include 'processor/db.php';

$result = mysql_query ("SELECT * FROM r_Groups WHERE EndDate < DATE_FORMAT($today, '%m%d%Y') AND StartDate >= DATE_FORMAT($today, '%m%d%Y'));
while ($row = mysql_fetch_array($result)) {

echo $row['GroupName'];
echo "<br>";

}

[Kudose]

Missing closing double quote on mysql_query