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" <balwantsingh@xxxxxxxxxxxxx> wrote in message news:000801c493f8$05bd96e0$5702a8c1@xxxxxxxxxx > 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:peppe1001@xxxxxxxxxxx] > Sent: Monday, September 06, 2004 2:45 PM > To: php-db@xxxxxxxxxxxxx > Subject: 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
