我试图弄清楚我在这里做错了什么。我想要格式化date_published
我的查询中的字段,我得到了t_string syntax error
在我的 IDE 中。
$this->db->select('site_news_articles.article_title, site_news_articles.is_sticky,' date_format('site_news_articles.date_published, 'f jS, Y')');
UPDATE:
function getNewsTitles($category_id) {
$this->db->select('site_news_articles.article_title, site_news_articles.is_sticky');
$this->db->select("DATE_FORMAT(site_news_articles.date_published, '%M %e, %Y') as formatted_date", TRUE);
$this->db->from('site_news_articles');
$this->db->where('site_news_articles.news_category_id', $category_id);
$this->db->where('site_news_articles.is_approved', 'Yes');
$this->db->where('site_news_articles.status_id', 1);
$this->db->order_by('site_news_articles.date_published', 'desc');
$this->db->limit(10);
$query = $this->db->get();
return $query->result_array();
}
错误号:1064
您的 SQL 语法有错误;检查与您的 MySQL 服务器版本相对应的手册,了解在 'FROM ( 附近使用的正确语法site_news_articles
) WHERE site_news_articles
.news_category_id
= 2 A' 在第 2 行
SELECT site_news_articles
.article_title
, site_news_articles
.is_sticky
, DATE_FORMAT(site_news_articles.date_published,'%M
%e, %Y')
作为 formatted_date FROM (site_news_articles
) WHERE site_news_articles
.news_category_id
= 2 且site_news_articles
.is_approved
=“是”并且site_news_articles
.status_id
= 1 订购依据site_news_articles
.date_published
描述 LIMIT 10
文件名:/home/xtremer/public_html/models/sitemodel.php
线路数量:140