Date Problem [Novice]

Anon

Hi,
I am having a problem extracting classes from the database that are 45 days out.

Right now everything shows up without the WHERE statement.

Bottomline: I just want to view the schedule of classes that are 45 days out or greater. And it's driving me nuts.

Here is the code:

$fortyfive_days = time() + (606024*45);
$classdate = date('Y-m-d', $fortyfive_days);

$sql = "
select id, coursecode, coursename, startdate, starttime, stopdate
from $table_name
order by startdate
WHERE startdate >= $classdate
";

I would appreciate any help, ideas, etc.

Thanks

mistcat

put your where clause before the order by clause.

Anon

OK Thank You. However it is still showing the entire schedule (past, present and future). I would like to see the future 45 days out and greater.

Here's the entire code:

include("common.php");

$db_name = "$db";

$table_name = "$table";

$fortyfive_days = time() + (606024*45);
$classdate = date('Y-m-d', $fortyfive_days);

$connection = @mysql_connect("$server", "$user", "$password") or
die("Couldn't connect.");

$db = @mysql_select_db($db_name, $connection) or die("Couldn't select
database.");

$sql = "
select id, coursecode, coursename, startdate, starttime, stopdate
from $table_name
WHERE startdate >= $classdate
order by startdate
";

$result = @($sql,$connection) or die("Couldn't execute query.");

$courses = "
<table width=700 cellpadding=3 cellspacing=3 border=0>
<tr>
<td bgcolor=#0ED8D6 width=100>Course Code:</td>
<td bgcolor=#0ED8D6 width=300>Course Name:</td>
<td bgcolor=#0ED8D6 width=100>Start Date:</td>
<td bgcolor=#0ED8D6 width=100>Start Time:</td>
<td bgcolor=#0ED8D6 width=100>End Date:</td>
</tr>
";

while ($row = mysql_fetch_array($result)) {

$id = $row['id'];
$coursecode = $row['coursecode'];
$coursename = $row['coursename'];
$startdate = $row['startdate'];
$starttime = $row['starttime'];
$stopdate = $row['stopdate'];

$courses .= "<tr>
<td bgcolor=#ECDC94 width=100>$coursecode</td>
<td bgcolor=#ECDC94 width=300>$coursename</td>
<td bgcolor=#ECDC94 width=100>$startdate</td>
<td bgcolor=#ECDC94 width=100>$starttime</td>
<td bgcolor=#ECDC94 width=100>$stopdate</td>
</tr>";

}

$courses .= "</table>";

Thanks for any help.

:o) Ivan

nate parsons wrote:

put your where clause before the order by clause.

majik-sheff

try this for your SQL:

SELECT id, coursecode, coursename, startdate, starttime, stopdate
FROM $table_name
WHERE startdate >= DATE_ADD(CURRENT_DATE, INTERVAL 45 DAY)
ORDER BY startdate

Anon

Works Great!!!

Thanks
Majik Sheff