Populate new fields

This topic is locked

Populate new fields	6/16/2006 12:24:22 PM
PHPRunner General questions
O osluk author Some new fields are required. I have added them to the database (MySql) Now I need to correctly populate the existing 500+ records with a checkbox for 2005 Vintage and En Primeur Can I do this in PHPrunner or is it possible to do it in PHP MySql. Cheers Chris


	Sergey Kornilov admin 6/16/2006
	You need to run a SQL query using MySQL command line or phpMyAdmin. `update tablename set checkboxfield=1 where ...` If you need more help post here your table structure and more details about what you need to populate.