$Information=M("Information"); //实例化information对象(对应金币信息表)
$InformationData=$Information->query("SELECT *
FROM `coin_information` , `coin_record`
WHERE coin_information.opid = 'oXOWrwtvdXOTEk8_QnxxC23rQxvY'
AND coin_record.opid = 'oXOWrwtvdXOTEk8_QnxxC23rQxvY'
AND coin_information.date
BETWEEN '2015-9-28'
AND '2015-10-4'
ORDER BY coin_information.date ASC");
最佳答案