ระบบประเมินจ้า

2017-02-02
-----------------------------------
SELECT personal_tb.Teacher_name, personal_tb.Teacher_lastname, personal_tb.secure_code, user_tb.Username, user_tb.PasswordR
FROM personal_tb
INNER JOIN user_tb ON personal_tb.Teacher_code = user_tb.Teacher_code
WHERE personal_tb.temp = 't'
ORDER BY personal_tb.numbers
LIMIT 0 , 60
------------------------------------------------------------


SELECT personal_tb.Teacher_code, personal_tb.Teacher_name, personal_tb.Teacher_lastname, user_tb.Username, user_tb.PasswordR, user_tb.Password
FROM personal_tb
INNER JOIN user_tb ON personal_tb.Teacher_code = user_tb.Teacher_code where personal_tb.temp='t' order by personal_tb.numbers