我想要MySQLI查询中的所有记录,其中task_start_date超过3天。
这是我尝试使用mysqli查询的方法:
$sql_task = "SELECT * FROM task where task_assignee='" . $user_result['id']."' WHERE task_start_date > DATE_SUB(NOW(), INTERVAL 5 DAY)";
$result_task_dropdown = mysqli_query($conn, $sql_task);
echo mysqli_error($conn);
$rows_task_dropdown=mysqli_num_rows($result_task_dropdown);
$task_dr_result = mysqli_fetch_array($rows_task_dropdown,MYSQLI_ASSOC);
这是我的任务表结构
CREATE TABLE `task` (
`task_id` int(11) NOT NULL,
`task_name` varchar(255) NOT NULL,
`task_description` text NOT NULL,
`task_assignee` varchar(255) NOT NULL,
`task_start_date` date NOT NULL,
`task_due_date` date NOT NULL,
`task_priority` varchar(50) NOT NULL,
`task_status` varchar(40) NOT NULL,
`task_remarks` text NOT NULL,
`location` varchar(200) NOT NULL,
`delete_status` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
$sql_task = "SELECT * FROM task where task_assignee='" . $user_result['id']."' and task_start_date < DATE_SUB(NOW(), INTERVAL 3 DAY)";
希望这对您有帮助。