Querying

[ec]

<?php

echo '<form>';

$query1 = mysql_query("SELECT detentiondate FROM detentiondates WHERE detentiondate NOT IN (SELECT detentiondate FROM detention WHERE '".$_SESSION['pupilno']."' = pupilno)"); 

while ($row = mysql_fetch_assoc($query1)){
   echo "$row[detentiondate]";
   echo "<input type='radio' name='choice' value='{$row['detentiondate']}'><br>";

}

 

I'm trying to add more to this query so that only dates which are 3 days or more away from today would be displayed as the result of this query.  Anyone any ideas?

 

I've tried adding in

$t=getdate();
    
$currentdate=date('Y-m-d',$t[0]);

$newcurrentdate = date("Y-m-d", mktime(0,0,0, date(m), date(d)+3,date(Y))); 

and then variations to the end of the query like AND IF $newcurrentdate < detentiondate but nothing's been working...

 

 

 

[Cep]

This not correct! But it should give you an idea

 

<?php
$sql = mysql_query("SELECT detentiondate FROM detentiondates WHERE detentiondate <= {$dateplus3} AND pupilno != '".$_SESSION['pupilno']."')"); 
?>

 

 

[sasa]

$query1 = mysql_query("SELECT detentiondate FROM detentiondates WHERE detentiondate NOT IN (SELECT detentiondate FROM detention WHERE '".$_SESSION['pupilno']."' = pupilno) AND '$newcurrentdate' < detentiondate");