Commit | Line | Data |
---|---|---|
a12d11db | 1 | <pre> |
f7740b1c | 2 | <h1>-- populate columns item_date_bought and item_date_sold</h1><?php |
a12d11db | 3 | $data = $this->db->safe_query_fetch('SELECT item_id,MIN(item_valid_from) AS min,MAX(item_valid_from) AS max FROM item GROUP BY item_id;'); |
79cc0871 TM |
4 | //print_r($data); |
5 | echo("START TRANSACTION;\n"); | |
a12d11db | 6 | foreach($data as $line) echo("UPDATE item SET item_date_bought='".$line['min']."',item_date_sold='".$line['max']."' WHERE item_id=".$line['item_id'].";\n"); |
79cc0871 | 7 | echo("COMMIT;\n"); |
a12d11db | 8 | ?> |
f7740b1c | 9 | </pre> |