这是我的原始查询
Select * FROM story st, sentences s, speaker sp
WHERE (st.lesson_id = '1' AND
st.speaker_id = sp.speaker_id AND
st.sentence_id = s.sentence_id)
当我尝试添加“订单依据”时,它会崩溃.
Select * FROM story st, sentences s, speaker sp
WHERE (st.lesson_id = '1' AND
st.speaker_id = sp.speaker_id AND
st.sentence_id = s.sentence_id) ORDER BY st.story_in_lesson_id ASC
无法弄清楚为什么它坏了.
编辑:
这是我得到致命错误的错误:调用成员函数fetch_object()
编辑:
我的PHP代码
$result = $mysqli->query("Select * FROM story st, sentences s, speaker sp
WHERE st.lesson_id = '1' AND
st.speaker_id = sp.speaker_id AND
st.sentence_id = s.sentence_id
ORDER BY st.story_in_lesson_id ASC");
while ($value = $result->fetch_object()) {
//never goes in here fails at the fetch_object()
}
编辑:
是否有可能因为我正在尝试查询多个表而无法使用?只有一个表具有Story_in_lesson_id,即Story表.当我只在该表上运行查询时,它可以找到.
编辑:
更多信息,将数据库复制到我的Mac上,查询成功!!!但是,为什么它在我的计算机上不起作用?顺便说一句,我现在只在Sequel Pro中运行它来严格测试查询.