I am developing a web site by using Joomla
And I need to get a data from data base under the following criteria
1. item should be a published (in my module published is 1 and unpublished is 0)
2. and selected data should be a shorting under the start data
I used following query for this...No problun query is executing perfectly....all the data also can display...but data not in shorting under the starting date...
SELECT * FROM `jos_jcalpro_events` WHERE `published` =1 ORDER BY 'start_date' ASC
please I am waiting your solutions
please help me.
in start_date value is having date and time together
eg: start_date = 2010-05-11 19:00:00 like this please tell me how I do this