sql查询相关问题

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

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

try the following to see your SQL then review :

$sql = "SELECT user_id,day,activity,hotel FROM wp_user_activity WHERE user_id = '$user_id' AND date BETWEEN $start AND $end ";

echo $sql; exit;

Now it is working. $arr=array(); foreach($results as $single) { $start = $single->trip_start_date; $end = $single->trip_end_date; /* return $sql = "SELECT user_id,day,activity,hotel FROM wp_user_activity WHERE user_id = '$user_id' AND date BETWEEN '$start' AND '$end' "; */ $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' "); $single->trip_details=$results; $arr[]=$single;

}