Теперь на такой код:
if (date("d") <= 20) { $a = date("Y-m-d H:i:s",mktime(date("H"), date("i"), date("s"), date("n")-1, 20, date("Y"))); } else { $a = date("Y-m-d H:i:s",mktime(date("H"), date("i"), date("s"), date("n"), 20, date("Y"))); } $res = sql_query("SELECT COUNT(f1680) AS counts FROM ".DATA_TABLE."130 WHERE status = 0 AND f1680 = '' AND f1750 = ".$line['Партнер']['raw']." AND strtotime(".$a.") >= strtotime(".$line['Дата заявки'].")"); $row = sql_fetch_assoc($res); $line['Партнер']['Заявки без статуса'] = $row['counts'];
выдает такую ошибку:
Цитата
14: AND strtotime(".$a.") >= strtotime(".$line['f1670'].")");
15: $row = sql_fetch_assoc($res);
Ошибка SQL запроса:
SELECT COUNT(f1680) AS counts FROM f_data130 WHERE status = 0 AND f1680 = '' AND f1750 = 2 AND strtotime(2015-08-20 10:38:47) >= strtotime(2015-09-01 13:04:00)
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 '10:38:47) >= strtotime(2015-09-01 13:04:00)' at line 6
В чем причина? подскажите, пожалуйста.