sql查询相关问题

Question

I have one more question in want to the user between the operator in php. This is my SQL query.

$results=$wpdb->get_results( "SELECT user_id,day,activity,hotel 
FROM wp_user_activity 
WHERE user_id = '$user_id' AND date BETWEEN $start AND $end "); 

it gives me an error

$results=$wpdb->get_results( "SELECT user_id,day,activity,hotel 
FROM wp_user_activity 
WHERE user_id = '$user_id' AND date BETWEEN '26/05/2019' AND '31/05/2019' "); 

am getting data in this why in the $start and $end am not getting any data

Answer 1

your date format is wrong please use standard date format that is YYYY-MM-DD Use this

$results=$wpdb->get_results( "SELECT user_id,day,activity,hotel 
FROM wp_user_activity 
WHERE user_id = '$user_id' AND date BETWEEN '2019-05-26' AND '2019-05-31' "); 

Hope this will help you