 |
|
|
 |
 |
|
ค้นหาเองจนเจอครับ ผิดนิดเดียว
ไปแก้ที่ Recent.php ครับ (แก้ตัวอักษรสีแดงครับ)
SELECT m.posterTime, m2.subject, m.ID_TOPIC, t.ID_BOARD, m.posterName, t.numReplies, t.ID_FIRST_MSG
FROM {$db_prefix}boards AS b, {$db_prefix}categories AS c
LEFT JOIN {$db_prefix}topics AS t ON (t.ID_TOPIC= 'b.ID_LAST_TOPIC')
LEFT JOIN {$db_prefix}messages AS m ON (m.ID_MSG= 't.ID_LAST_MSG')
LEFT JOIN {$db_prefix}messages AS m2 ON (m2.ID_MSG= 't.ID_FIRST_MSG') 'b.ID_LAST_TOPIC') 't.ID_LAST_MSG') 't.ID_FIRST_MSG') 
|
 |
 |
 |
 |
| Date :
22 มี.ค. 2551 02:18:10 |
By :
tawat |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
SELECT m.posterTime, m2.subject, m.ID_TOPIC, t.ID_BOARD, m.posterName,
t.numReplies, t.ID_FIRST_MSG
FROM {$db_prefix}boards AS b, {$db_prefix}categories AS c
LEFT JOIN {$db_prefix}topics AS t ON (t.ID_TOPIC='b.ID_LAST_TOPIC')
LEFT JOIN {$db_prefix}messages AS m ON (m.ID_MSG='t.ID_LAST_MSG')
LEFT JOIN {$db_prefix}messages AS m2 ON (m2.ID_MSG= 't.ID_FIRST_MSG')
นิดเดียวหาแทบ .......
|
| |
|
|
| |
| Date :
9 มิ.ย. 2551 22:00:20 |
By :
pupotter |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
