mysql - 如何避免sql查询中出现多余的引号

Question

$select->join($dtr, "$dt.TableId=$dtr.TableId AND "."$dtr.".'StartTime NOT BETWEEN '.'"'.$Time.'"', array(),'left');
             $select->where->equalTo("$dt.". 'SeatingCapacity', $wherearray['Size']);  

它给了我这样的结果

 SELECT "dining_table"."TableId" AS "TableId", "dining_table"."TableName" AS "TableName", "dining_table"."StoreId" AS "StoreId" FROM "dining_table" LEFT JOIN "dining_table_reservation" ON "dining_table"."TableId"="dining_table_reservation"."TableId" AND "dining_table_reservation"."StartTime" "NOT" BETWEEN "\"""2015""-""10""-""15" "17"":""40"":""20" AND "2015""-""10""-""15" "17"":""40"":""20""\"" WHERE "dining_table"."SeatingCapacity" = '4'

但我想要的时间格式为 NOT BETWEEN '2015-10-15 17:40:20' AND '2015-10-15 17:40:20'

我应该做什么？

Answer 1

我已编辑我的查询。请看一下

<?php
$dtr="dining_table_reservation" ;
$dt="dining_table"; 
$time="2015-10-12 06:39:24";
$time2="2015-10-12 08:39:24";

$select->join($dtr, " ".$dt.".TableId=".$dtr.".TableId AND ".$dtr.".StartTime NOT BETWEEN '".$time."' AND '".$time2."' ", array(),'left');
             $select->where->equalTo("".$dt.".SeatingCapacity", $wherearray['Size']);