PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE `notice` ( `id` int, `time` time, `time_update` time, `current_value` int );
Copy Clear
Copy Format Clear
<?php $query = "UPDATE `notice` SET `time_update` = ?, `current_value` = ? WHERE `id` = ? AND `time_update` = `time`;"; // get DB version using PDO $stmt = $pdo->prepare($query); $stmt->execute([$time, $query_price_data['lastprice'], $rows['id']]);
Show:  
Copy Clear