2
ссылка в отчете
http://tmp.clientbas....08.2013&type=d
Array
(
[0] => Array
(
[field] => 1157
[term] => period
[value_field] => 15.07.2013
[value_field2] => 11.08.2013
[union] => and
)
[1] => Array
(
[field] => 438
[term] => =
[value_field] => 10
[union] =>
)
)
$_SESSION[$ses_id]['search'][42][0]['field'] = 1157;
$_SESSION[$ses_id]['search'][42][0]['term'] = "period";
$_SESSION[$ses_id]['search'][42][0]['value_field'] = form_local_time($_REQUEST['date1']);
$_SESSION[$ses_id]['search'][42][0]['value_field2'] = form_local_time($_REQUEST['date2']);
$_SESSION[$ses_id]['search'][42][0]['union'] = " and ";
$_SESSION[$ses_id]['search'][42][1]['field'] = 438;
$_SESSION[$ses_id]['search'][42][1]['term'] = "=";
$_SESSION[$ses_id]['search'][42][1]['value_field'] = $_GET['manager'];
$_SESSION[$ses_id]['search'][42][1]['union'] = "";
header("Location: ".$config["site_root"]."/fields.php?table=42&filter=48");
В итоге по нажатию на ссылку получаю:
SQL error in SELECT count(*) as total_rec FROM f5_data42 WHERE status=0 and ((left(f1157,10)>='0000-00-00' and left(f1157,10)<='9999-99-99') and abs(f438)=''f2445'') 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 'f2445'')' at line 1 In function: /home/s/smartmedia/nmd.webtm.ru/public_html/fields.php(951) : sql_query()
Если оставляю только это:
$_SESSION[$ses_id]['search'][42][1]['field'] = 438;
$_SESSION[$ses_id]['search'][42][1]['term'] = "=";
$_SESSION[$ses_id]['search'][42][1]['value_field'] = $_GET['manager'];
$_SESSION[$ses_id]['search'][42][1]['union'] = "";
header("Location: ".$config["site_root"]."/fields.php?table=42&filter=48");
Поиск отрабатывает, однако пишет, что поле менеджер = "", поле типа пользователь, айди пользователя передается.Что изменилось в 197?
