01.<?php
02.
03.$sql = "SELECT data_user.*,data_car.*,data_prb.*,data_ins.* FROM data_user
04.left JOIN data_car on data_user.id=data_car.id
05.left JOIN data_prb on data_user.id=data_prb.id
06.left join data_ins on data_user.id=data_ins.id
07.
08.##WHERE (DATEDIFF(data_prb.prb_e,CURDATE())between 1 AND 30) AND
09.
10.WHERE data_user.member_id = '$_SESSION[login_true]'
11.ORDER BY data_prb.prb_e ASC
12.LIMIT 30";
13.$query = $conn->query($sql) or die( $conn->error. "<br>$sql");
14.?>
