Thread

Hi All,

I have a simple question for a problem i cannot get my head around:

this works (returns a result):

$query = $this->EE->db->query("SELECT hguid AS HGUID
FROM table
ORDER BY date DESC
LIMIT 0 , 1");

this doesn’t (no results):

$query = $this->EE->db->select('hguid AS HGUID')->from('table')->order_by('date', 'desc')->limit(0,1)->get();

Note: I have also tried the none method chaining way and still no luck

Any Ideas?

It is the order of arguments to the limit() method. It should be:

->limit(1, 0)

excellent!! no idea why i missed that.