Commit | Line | Data |
---|---|---|
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;'); | |
3 | //print_r($data); | |
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"); | |
6 | echo("COMMIT;\n"); |