showing query

[peppeto]

Hi ,
I have a problem with showing a query I have a table project with start date and end date and project title
I want to show only the projects that they are given in table for that month for example project that starts 06-09-04 and ends 09-09-04 or ends 12-02-05
I have a function called getToday

function getToday() {
$date = getdate();
return sprintf("%04d-%02d-%02d", $date["year"], $date["mon"], $date["mday"]);
return $date;
}

$today= getToday();
$day = substr($today, 8, 2);
$month = substr($today, 5, 2);
$year = substr($today, 0, 4);
Any help will be appreciated

[Weedpacket]

Perhaps you'll find [man]date[/man] a more useful function, here.

Assuming you're using a date field to store your date, date('Y-m-d') will return today's day in a format suitable for inserting into the query and using the DBMS's own date-handling functions and operators.