Приветствую, прошу помочь исправить ошибку в запросе, сам запрос :
if( $_GET['folder'] == "outbox" ) {
$lang['pm_from'] = $lang['pm_to'];
$sql = "SELECT id, text, subj, foto, name as user_from, date, pm_read FROM ".USERPREFIX."_pm LEFT JOIN ".USERPREFIX."_users ON " . USERPREFIX . "_pm.user=" . USERPREFIX . "_users.user_id WHERE user_from = '{$member_id['name']}' AND folder = 'outbox' order by date desc" . $cstart . "," . $pm_per_page;
$user_query = "do=pm&folder=outbox";
} else {
$sql = "SELECT foto, text, id, subj, user_from, date, pm_read, reply, us.lastdate as lastdate FROM " . USERPREFIX . "_pm, " . USERPREFIX . "_users us where user_from = us.name AND user = '{$member_id['user_id']}' order by date desc" . $cstart . "," . $pm_per_page;
$user_query = "do=pm";
}
пишет ошибку:
The Error returned was:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near desc0, at line 1
Error Number:
1064
думаю что то
. $cstart . "," . $pm_per_page;
, прошу вашей помощи, заранее спасибо!
Источник:
dle-faq.pro, DLE