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
