CREATE TABLE IF NOT EXISTS `quotation_table` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `bidData` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `symbol` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `quota` double NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `bidData` (`bidData`,`symbol`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

$link = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbusername,$dbpassword);
	
	$from = date('Y-m-d H:i:s');
	$time = strtotime("now - 1 minute");
	$to = date('Y-m-d H:i:s',$time);
	
	$statement = $link->prepare("SELECT `quota`, `bidData` FROM `quotation_table` WHERE `symbol` = AUDJPY AND `bidData` >= '".$to."' AND `bidData` <= '".$from."'");
	
	$statement->execute();
	$row = $statement->fetchAll();
	
	print_r($row);