help, help, date from MySQL with DB Class

[karsen]

Faguss posted the solution, but here is why your code didn't work. The problem with your original query is you are trying to use echo, which only prints strings. $today is an object that was returned by $db->query(), so you'd need echo out the object property (or convert it to an array first if you are more comfortable with them).

$db->first() returns the first row as an object, and passing a true value will tell it to return an array instead. This is extremely useful when you know you will only have one row:

Code:

$db->first(true) // this will return an array

Now that it's an object/array of just the first row, you can echo the data as you please:

Code:

$result = $db->query("SELECT NOW() as 'now'")->first();

Code:

echo $result->now; // as an object

Code:

$result = $db->query("SELECT NOW() as 'now'")->first(true);

Code:

echo $result['now']; // as an array