| (huberthsu) |
| ArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayselect a.cid, a.name, a.en_begin, a.en_end, a.st_begin, a.st_end, a.state, substring(a.content,0) as content, a.teacher, b.permit as tp, b.post, b.hw, b.qp, b.exam, b.total_node, b.degree, b.bookmark, CASE a.state WHEN 0 THEN 1 WHEN 2 THEN IFNULL((CURDATE() > a.st_end),0) WHEN 4 THEN IFNULL((CURDATE() > a.st_end),0) ELSE 0 END as issty from WM_class AS a, WM_select AS b WHERE (a.sid=10005) AND (b.username='huberthsu') AND (a.cid=b.cid) order by b.login_times DESC, a.cid |
http://kh.k12.edu.tw/
k12.ppthttp://teaching.moe.gov.tw/2006CD/files/enjoy/hi/c010015/c0100151/K12.ppt
沒有留言:
張貼留言