sql - PHP query for a month but gives me last two years

Solution:

You will want to add this to your WHERE clause as well:

YEAR(lbs_date) to YEAR(NOW())
Copy code

What your query is asking for now is: give me rows for this client with an lbs_date in March. Instead, what you want it is: give me rows for this client with an lbs_date in March of this year.

Solution:

addand YEAR(lbs_date)=YEAR(NOW());

Solution:

I don't know which DB engine you are using so you will need to translate the sample (it is also untested but you get the idea) to be relevant but you just need to give it a better comparison date

$query = "SELECT * FROM lbs_trace_etrack WHERE lbs_client='$slcustom1' AND lbs_date <= dateadd(month,1,NOW())";
Copy code

or if you want to return dates less than the end of the month you could use

$query = "SELECT * FROM lbs_trace_etrack WHERE lbs_client='$slcustom1' AND lbs_date <= dateadd(month,1,dateadd(day,day(NOW()) * -1,now())";
Copy code