INSERT TABLE isn't allowed in FROM table list

[corsacrazy]

have an error on a non vb project im working on this is the error

INSERT TABLE 'auctions' isn't allowed in FROM table list


any one tell me what is wrong ? thanks

[Marco van Herwaarden]

You can not use a table in the from clause if you are inserting into the same table.

Not sure if this is changed is later MySQL versions.

[corsacrazy]

its basically an auction scrip , the error comes after an auction is over and i press the relist auction button which should send the data back into the databse and thus relisting the item how ever thats the error i get :(

any more ideas?