CODEWITHSUNDEEP
mysqljoomla
Sadie
Sadie

Reputation: 19

Joomla JFactory query to return results after today's date

I'm trying to retrieve data from my Joomla! database, but I only want to return results after today (future dates). I've been trying the following, but it isn't working:

        ->select('*')
        ->from($params->get('table'))
        ->where('state = 1')
        ->where('eventdate' > date('Y-m-d'))
        ->order('eventdate');

What do I need to change?

Upvotes: 0

Views: 98

Answers (1)

Sadie
Sadie

Reputation: 19

I found my answer.

        ->select('*')
        ->from($params->get('table'))
        ->where('state = 1')
        ->where('eventdate >= CURDATE()')
        ->order('eventdate');

Upvotes: 1

Related Questions