php - Table starting from present date -


$sqlstr = "select name, datescheduled               table              datescheduled > now()           order datescheduled desc";       

i echo table results above. row each day next 90 days regardless of whether or not mysql table has entry day. how can this?

add:

$query1 = mysql_query($sqlstr);      echo "<table><tr>";     echo "<th>name</th><th>date scheduled</th>";         while ($rows = mysql_fetch_assoc($query1)) {             echo "<td>" .$rows['name']. "</td>";             echo "<td>" .$rows['datescheduled']. "</td>";             }         echo "</tr><table>"; 

Comments

Popular posts from this blog

java - Intellij Synchronizing output directories .. -

git - Initial Commit: "fatal: could not create leading directories of ..." -