Dave Carrera wrote:
> 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
This is a SQL question, not PHP. That said, what you're describing is
INSERT...SELECT syntax. In your example, something like:
INSERT INTO mytable (name, code, price)
SELECT 'NEW', code, '33' FROM mytable
WHERE name = 'BASE' /* or whatever rows you need to copy */
Supported by MySQL, PostGres and others.
--
Max Schwanekamp http://www.neptunewebworks.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
