Can't I select and insert data into the same table in PHP?

[Habtom]

Hi,

Can't I select and insert data into the same table in PHP?

$SQL = "INSERT INTO c (name, prices, prices2, del, loc) SELECT D.name, D.prices, D.prices2, D.del, 7777777 FROM c D WHERE D.loc = '". $_POST['txtCopyFrom'] ."'";

Hab

[Vastio]

I believe you need an UPDATE instead of an INSERT

[DrDoc]

Sure you can ... I do that all the time. Do you get an error?

[coopster]

... unless that table is running on a MySQL server prior to MySQL 4.0.14. The target table of the INSERT statement cannot appear in the FROM clause of the SELECT part of the query. This limitation is lifted in 4.0.14.