Sunil, Here is my recommendation, should be a little cleaner as well:
SELECT * FROM tableName WHERE dat_birth >= DATE_ADD(NOW(), INTERVAL 15 DAY) This keeps the work at the SQL server, and ensures that the date is valid. V/r, Charles --- In [email protected], praveen kumar <[EMAIL PROTECTED]> wrote: > > $today =date("Y-m-d"); > $day_15 = date("Y-m-d",mktime(0, 0, 0, date('m'), > date('d')+15, date('Y')) ); > > $Query = "SELECT * from tablename where dat_birth >= > '$today' and dat_birth <= '$day_15' " > > I think it helpfull u > > Thanks & Regards > Praveen Kumar M > tantravahi srinivas sunilkumar > <[EMAIL PROTECTED]> wrote: hi , > > I am having the dat_birth field in my database.I > want to have the query of getting the next 15 days > from today and want to retrieve the results by > comparing with that dat_birth field. > > thanks in advance for the help. > > ragards, > sunil. > > > --------------------------------- > Brings words and photos together (easily) with > PhotoMail - it's free and works with Yahoo! Mail. > > [Non-text portions of this message have been removed] > > > > Community email addresses: > Post message: [email protected] > Subscribe: [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > List owner: [EMAIL PROTECTED] > > Shortcut URL to this page: > http://groups.yahoo.com/group/php-list > > > > SPONSORED LINKS > > Php mysql Job > postings > > > --------------------------------- > YAHOO! GROUPS LINKS > > > Visit your group "php-list" on the web. > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! > Terms of Service. > > > --------------------------------- > > > > > > > > __________________________________________________________ > Yahoo! India Matrimony: Find your partner now. Go to http://yahoo.shaadi.com > Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
