How to retrieve data from database (PHP)?

Question

PHP

Help, please) there is a table `p_operativ`. I enter the date there in the form: they $date = (date("Y.m.d"));
are entered into the database in the form of 2015-12-08 type date. Further I want to display the request the data relating to a certain date. I define the date like this:

$v = date ("Y-m-d", time() - ( -1 + date("N")-1) * 24*60*60);

(we need dates in the current week. this is Tuesday) and the query itself to the database

$hz_query = "select * from `p_operativ`
    where `po_agent` = ".$id_row['p_user_id']." and `po_date` = ".$v;
    $hz_res = mysql_query($hz_query) or die(mysql_error());
    $d = mysql_num_rows($hz_res);
    $hz_row = mysql_fetch_assoc($hz_res);

var_damp outputs: string(81) "select * from `p_operativ` where `po_agent` = 188 and `po_date` = 2016-02-25"
but no data is output. mysql_num_rows says 0. how to display correctly?

Answer 1

And it's not about the quotation marks around the date?

Answer 2

see which of the conditions returns 0 rows..

Answer 3

the one associated with the date. if you remove and `po_date` = ".$v then the data is displayed

Answer 4

1. where you make a date, use mktime
2. if you need days from today (for example, 7 days from today), then filter at the mysql level,
see dev.mysql.com/doc/refman/5.7/en/date-and-time-func ...
interval bugs you