又遇见一个小问题,求救

sylier

我的sql语句如下:

SQL复制代码

SELECT id,LEFT(title,20),author,LEFT(body,100),DATE FROM entries ORDER BY id DESC LIMIT 3

复制代码

我直接用命令行运行可以,但是网页上却提示这样的错误:

1. A PHP Error was encounteredSeverity: NoticeMessage: Undefined property: stdClass::$titleFilename: views/page.phpLine Number: 19

复制代码

请大家帮忙看看出了什么问题.

sylier

...貌似没人,我还是用substr()这个php函数算了.

sonic

select id,left(title,20) as title_left,author,left(body,100) as body_left,date from entries order by id desc limit 3

请注意alias~~别名才可以提取。

sylier

回复 3# sonic

感激不尽....
以后还请继续关照.

sonic

回复 4# sylier

别客气呀，互相学习