1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
|
$sql = "SELECT
tab2.id, tab2.name, tab2.email, tab2.betr_pre,
tab2.betr, tab2.savetime, tab2.ip, tab2.msg, tab3.betr AS betr_pre
FROM
".$TAB."contact_resp AS tab1,
".$TAB."contact_msg AS tab2,
".$TAB."contact_betr AS tab3
WHERE
tab2.id <> tab1.msg_id
AND tab2.betr_pre = tab3.id
ORDER BY
$ordercol $orderdir
"; |