1 <pre
><h1
>populate column item_date_bought
</h1
><?php
2 $data = $this->db
->safe_query_fetch('SELECT item_id,MIN(item_valid_from) AS item_valid_from FROM item GROUP BY item_id;');
4 echo("START TRANSACTION;\n");
5 foreach($data as $line) echo("UPDATE item SET item_date_bought='".$line['item_valid_from']."' WHERE item_id=".$line['item_id'].";\n");