if ($_GET['napravl'] == 'yes') { $_SESSION[$ses_id]['search'][93][0]['field'] = 1221; $_SESSION[$ses_id]['search'][93][0]['term'] = "period"; $_SESSION[$ses_id]['search'][93][0]['value_field'] = form_local_time($_GET['d1'] . " 00:00"); $_SESSION[$ses_id]['search'][93][0]['value_field2'] = form_local_time($_GET['d2'] . " 23:59"); $_SESSION[$ses_id]['search'][93][0]['union'] = " and "; $_SESSION[$ses_id]['search'][93][1]['field'] = 1919; $_SESSION[$ses_id]['search'][93][1]['term'] = "="; $_SESSION[$ses_id]['search'][93][1]['value_field'] = $_GET['v']; header("Location: " . $config["site_root"] . "/fields.php?table=93");
Ошибка:
SQL error in SELECT count(*) as total_rec FROM f5_data93 WHERE status=0 and ((left(f1221,10)>='0000-00-00' and left(f1221,10)<='9999-99-99') and f1919=''f2419'') 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 'f2419'')' at line 1 In function: /home/s/smartmedia/1.smartmd.ru/public_html/fields.php(950) : sql_query()Ревизия последняя. Что делать?