database - wpdb->get row Select (相当复杂) 查询不起作用

Question

拜托，有人可以告诉我这个数据库查询中的错误是什么？它不想为某事工作：S

这是完整的功能：

function foglaltautok(){

    global $wpdb;

    $carname     = $_POST['car-model'];
    $pickupdate  = $_POST['pick-up-date'];
    $dropoffdate = $_POST['drop-off-date'];
    $days        = (strtotime($dropoffdate) - strtotime($pickupdate)) / (60 * 60 * 24)+1;

    $foglaltvagynem = $wpdb->get_row("SELECT carmodel 
        FROM autofoglalt 
        WHERE carmodel = $carname 
            && ($pickupdate BETWEEN  pickupdate AND  dropoffdate 
            OR $dropoffdate BETWEEN  pickupdate AND  dropoffdate 
            OR pickupdate   BETWEEN $pickupdate AND $dropoffdate 
            OR dropoffdate  BETWEEN $pickupdate AND $dropoffdate)"); 

    if(null!==$foglaltvagynem) {
        echo 'error';   
    }
    else 
        if(null === $foglaltvagynem) {
            $wpdb->insert('autofoglalt', array(
                'carmodel'    => $carname,
                'pickupdate'  => $pickupdate,
                'dropoffdate' => $dropoffdate,
                'napok'       => $days
            ));
        }

    die();
}

这部分不起作用：S：

$foglaltvagynem = $wpdb->get_row("SELECT carmodel 
    FROM autofoglalt 
    WHERE carmodel = $carname 
    && ($pickupdate     BETWEEN  pickupdate AND  dropoffdate 
        OR $dropoffdate BETWEEN  pickupdate AND  dropoffdate 
        OR pickupdate   BETWEEN $pickupdate AND $dropoffdate 
        OR dropoffdate  BETWEEN $pickupdate AND $dropoffdate)"
    );

我将此代码写入汽车租赁页面，并且通过此查询我想知道，所选汽车是免费的还是保留的 - 从所选的pickupdate - 到所选的 dropoffdate..- 所以它已经在数据库中了，还是没有？:)

标签： databasewordpressselect