RE: [PHP-DB] how to show this querry
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
Re: [PHP-DB] how to show this querry
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
