FuelPHP Forums

I'm trying to insert into a MySQL database table something like the following but can't figure out the right syntax for setting the field "expiration".

$set['first_name'] = 'Joe';
$set['last_name'] = 'Smith';
...
$sql = "DATE_ADD(NOW(), INTERVAL (SELECT expiration_days FROM options_access WHERE access_id = $access_id) DAY)";
$set['expiration'] = "DB::expr($sql)";

$query = DB::insert('clients)->set($set);
$query->execute();