Hi All, I have a table with a structure like this. name code price what i would like to do is copy the data in these rows to new ones in the same table but change the name col, keep the current data for code col and set price col to a default value. so if the output of my current table is BASE 600 1.99 BASE 601 2.99 then i would like to copy these rows so that the table looks like this BASE 600 1.99 BASE 601 2.99 NEW 600 33 NEW 601 33 i hope that makes some kind of sence... Dave C -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
