PLease Help.....
Posted: Tue Nov 17, 2009 11:43 pm
Hi,
My application needed that:
i have no of topics (100 topics) shows after the login (by usder id and password),
my topics enabled by date, now i want to display the topic of the day after topic name by seeing the date, if any topic found on the system date then AFter topic name DIsplay a text that "New Topic" if not found any topic in the date then display the just less date from the current date as the new topic, here is the problem my dates are not in the Serial such that 2009-10-11, 2009-10-12, 2009-10-13... etc, my dates are 2009-10-11, 2009-10-15, 2009-10-16,2009-18... etc. i want the just less date from the system date.
if i fire the Query
SQL >> select * from time_table where time_table_date<'2009-11-2009';
after execute this Query this gives me all the less date data from the System date, but i want just immediate less date data.
Please help me out i m stuck in the code, and i have written many line codes but not found the solutions..................... Please
Thanks in ADV.
My application needed that:
i have no of topics (100 topics) shows after the login (by usder id and password),
my topics enabled by date, now i want to display the topic of the day after topic name by seeing the date, if any topic found on the system date then AFter topic name DIsplay a text that "New Topic" if not found any topic in the date then display the just less date from the current date as the new topic, here is the problem my dates are not in the Serial such that 2009-10-11, 2009-10-12, 2009-10-13... etc, my dates are 2009-10-11, 2009-10-15, 2009-10-16,2009-18... etc. i want the just less date from the system date.
if i fire the Query
SQL >> select * from time_table where time_table_date<'2009-11-2009';
after execute this Query this gives me all the less date data from the System date, but i want just immediate less date data.
Please help me out i m stuck in the code, and i have written many line codes but not found the solutions..................... Please
Thanks in ADV.