Question

如何将下列语句转换为thinkphp形式，不用原生query()

$sql = "select * from tp_dc_cart where LEFT(buytime,10) <= '$end' and LEFT(buytime,10) >= '$start' and bid = '$bid' and status in (2,6)

• 你的回答被采纳后将获得：
• 系统奖励15（财富值+成长值）+难题奖励30（财富值+成长值）

Answer 1

M('tp_dc_cart')->where('LEFT(buytime,10)<='.$end.' and left(buytime,10).......')