I have a problem in using the to_char function in a SQL-Statement
and addressing it with DB_FETCHMODE_OBJECT under PEAR DB.
The follwing code is working fine unless I'm adding the to_char function:
--------------------------------------------------------------
require_once 'DB.php';
$dsn = $$$;
$db = DB::connect($dsn);
$db->setFetchMode(DB_FETCHMODE_OBJECT);
$query .= "SELECT news_id,to_char(news_time,'DD.MM.YYYY HH24:MI'), ";
$query .= "FROM News ";
$query .= "WHERE news_id=$var";
$sth = $db->query($query);
while($newsid_row=$sth->fetchRow()) {
print <<<HTML
$newsid_row->news_id<br> <!-- there's an output -->
$newsid_row->news_time<br> <!-- there's no output -->
blabla
HTML;
}
$db->disconnect();
--------------------------------------------------------------
Has anybody an idea to get this working or similar experiences?
Thanks for your patience; could be the wrong newsgroup!?
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
