[請益] LIMIT用法錯誤嗎
小弟是php新手
最近在研究網站,遇到一個瓶頸
想要從goods這個資料表裡面取出物品資料,
並且按照更新日期降冪排列取出20個最近變動過的
另外good_visible這個屬性值為一代表這不是隱藏商品這樣
但是....
SELECT *
FROM goods
WHERE goods_visible = 1
ORDER BY goods_date DESC limit 20
請問各位大大這樣打有錯誤嗎
因為我網頁run下去之後出現
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'LIMIT 0, 18' at
line 1
苦惱到炸掉阿!!!!!!!!
--
feel the muzik,
change the world .
http://www.wretch.cc/blog/kevinishere
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 123.193.69.240
→
11/22 11:19, , 1F
11/22 11:19, 1F
→
11/22 11:21, , 2F
11/22 11:21, 2F
→
11/22 11:24, , 3F
11/22 11:24, 3F
→
11/22 11:24, , 4F
11/22 11:24, 4F
→
11/22 11:55, , 5F
11/22 11:55, 5F
→
11/22 19:53, , 6F
11/22 19:53, 6F
→
11/23 01:32, , 7F
11/23 01:32, 7F