Hi Balwant your answer helpd me only I have a problem showing the projects starting 06-05-2004 and ending 09-09-2005 I need to show also those projects beacuse of end date is 2005
"Balwantsingh" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > try this > SELECT start_date, end_date, project_title from tablename where > month(start_date)=09 and year(start_date)=04 > > this will show only the data pertaining to 09 month and 04 year. > > hope this will resolve your problem. > > with best wishes > balwant > > -----Original Message----- > From: peppe [mailto:[EMAIL PROTECTED] > Sent: Monday, September 06, 2004 2:45 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] how to show this querry > > > Hi , > I have a problem with showing a query I have a table project with start date > 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 > but nt the projects that starts 06-10-04 > > Any help will be appreciated > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php