HiAll,
I want to execute below sql query using Drupal 7 PDO, But could not find a way to do,
SQL:
"UPDATE `books` AS a
JOIN `books` b ON a.pid = b.pid
SET a. `status` = 'INACTIVE'
WHERE b.`pdays` * (36400) + b.`ptime_from` > 6546"
Drupal 7:
$query = db_update('books','pb');
$query->fields($update_values);
$query->join('books', 'pc', 'pc.pid = pb.pid');
//$query->condition("pc.pdays" * (36400) + "pc.ptime_from",$today ,'>');
/* $query->expression('pc.pdays', 'pdays * :daytime + pc.ptime_from', array(':daytime' => '36400'),'>')*/
$isbn_reds = $query->execute();
How can we write above SQL in D7 PDO?
pdays
* (36400) + b.ptime_from
> 6546" in D7 PDO