[SOLVED] Select BETWEEN dates

[timmah1]

This query returns 0 results, even though there are 9 dates between the two.

 

Can anybody tell me why?

 

<?php
$sql = "SELECT * FROM lunch WHERE person = '".$_GET['id']."' AND date BETWEEN '".date("Y-m-d")."' AND '".date("Y-m-d", strtotime("+ 7 Days"))."'";
$result = mysql_query($sql);
$numrows = mysql_num_rows($result);

if($numrows == 0 ){
echo "No lunch for $p1 entered right now";
}
?>

 

Thanks in advance

[Maq]

Try:

 

AND date > DATE_SUB(NOW(), INTERVAL '1' WEEK)

 

Have you echoed out your query to see what's actually being passed?

 

Have you checked to see if your query died?

 

$result = mysql_query($sql) or die(mysql_error());

[roopurt18]

I'm not telling you anything until you properly escape your database inputs:

mysql_real_escape_string()

[timmah1]

I apologize Maq, and thank you, that worked like I needed it to

 

And roopurt18, you could have kept your comment to yourself, because in essence, you did tell me something :-)

 

[Maq]

I apologize Maq, and thank you, that worked like I needed it to

 

And roopurt18, you could have kept your comment to yourself, because in essence, you did tell me something :-)

 

 

He's just helping you...

[roopurt18]

I apologize Maq, and thank you, that worked like I needed it to

 

And roopurt18, you could have kept your comment to yourself, because in essence, you did tell me something :-)

 

 

Hehe

 

What I meant was I'm not helping you fix the problem you asked for help with until you fixed your other more serious problems.