Apple iPad-12 (1155-1312-025-43-1(1)/7-1(1)/2-1(1)/13-12(25)),
Lenovo-Thinkpad-01 (121/54-1312-060-03-1(30)),
Lenovo-Thinkpad-02 (121/54-1312-060-03-2(30)),
Lenovo-Thinkpad-03 (121/54-1312-060-03-3(30)),
Microsoft Surface-04 (1159-1312-060-08-4(15)/มทร.11ค/งปม.2559),
Microsoft Surface-05 (1159-1312-060-08-5(15)/มทร.11ค/งปม.2559),
Microsoft Surface-06 (1159-1312-060-08-6(15)/มทร.11ค/งปม.2559)
อยากได้เป็นแบบนี้
Quote:
Apple iPad (1155-1312-025-43-1(1)/7-1(1)/2-1(1)/13-12(25)),
Lenovo-Thinkpad (121/54-1312-060-03-1(30)), (121/54-1312-060-03-2(30)), (121/54-1312-060-03-3(30)),
Microsoft Surface (1159-1312-060-08-4(15)/มทร.11ค/งปม.2559), (1159-1312-060-08-5(15)/มทร.11ค/งปม.2559), (1159-1312-060-08-6(15)/มทร.11ค/งปม.2559)
คิวรี่ที่ใช้ Code (PHP)
SELECT user,
fullname,
log_id,
amount,
logs_status,
loan_by,
start_date,
end_date,
place,
GROUP_CONCAT(list,' (',code,')' ORDER BY list ASC SEPARATOR ', <br>') AS selected
FROM tbl_borrow_logs,tbl_machine
WHERE log_id = 1
AND logs_status = 'not return'
AND concat(',',item,',') LIKE concat('%,',machine_id,',%')
GROUP BY date_borrow
ORDER BY list DESC
Load balance : Server 04
Quote:
มรโครงสร้าง Table/Data ให้ดูหรือเปล่าครับ
