I am mysql newbie.
Please have alook at this querry.
SELECT b.date as date, a.tirthankar_name as tirthankar_name, a.kalyanak as kalyanak FROM table1 a, table2 b WHERE a.mass = b.mass AND a.paksh = b.paksh AND a.tithi = b.tithi AND b.date BETWEEN CURdate( ) AND (CURdate( ) +9) ORDER BY b.date LIMIT 0 , 1000;
I am trying to run this querry but it is giving zero rows as output while I am running it on my table.
It was running fine a few days ago but started bugging around 7-8 days back when curdate and curdate+9 range was in January month it self.
I assume the problem is mainly due to change in month from January to February which is causing this trouble.
Is there any better way to code this.
I want to put a few variables where date is today or 9 days from today (that is for next ten days including today).
The date field has values 2009-01-30 for today in both the tables.
Also it is runs and gives output if I change
"AND b.date BETWEEN CURdate( ) AND (CURdate( ) +9)"
"AND b.date BETWEEN CURdate( ) AND (CURdate( ) +75)"
Although does not gives output for next 75 days but it does output for next 5 days.
Its a bit urgent