Query does not work.You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘WHERE vehicle_id = 2 and now() and status = 1 order by id desc limit 1’ at line 1
my code
html
<form action="update2.php" method="post">
<p>
<label align-text="center" for="real_goe"><h3>place you go <h3></label>
<input type="text" name="real_go" class="form-control">
</p>
<button type="submit" class="btn btn-success">save</button>
</form>
code php
$a = $_POST["real_go"];
$sql ="UPDATE test_car.New_car_car_reservation SET real_go =$a WHERE vehicle_id = 2
and now()
and status = 1
order by id desc limit 1 ";
$query = mysqli_query($db,$sql);
if(!$query)
{
echo "Query does not work.".mysqli_error($db);die;
}
else
{
echo "<script>alert('save')</script>";
echo "<script>window.location='index2.php'</script>";
}