Welcome Guest, Not a member yet? Register   Sign In
Database query problems
#1

[eluser]nmormino[/eluser]
I tried using the database helper to write a query that would ultimately have the same function as

SELECT * FROM table_name WHERE date >= CURDATE()

I made an attempt at this by using

$this->db->where("date >= "=>date('Y-m-d'));
$this->db->orderby('date DESC');
$query = $this->db->get('table_name');

But this didn't return anything where as the manual SQL statement does return results.

any ideas?


Messages In This Thread
Database query problems - by El Forum - 01-04-2008, 12:14 PM
Database query problems - by El Forum - 01-04-2008, 01:05 PM
Database query problems - by El Forum - 01-04-2008, 01:13 PM



Theme © iAndrew 2016 - Forum software by © MyBB