using text fields to upload MySql query

[Anon]

Hello all,
I have a huge problem.
I recently created a website that enables anyone to see whats in the MySQl database supporting it. Basically what I'm trying to do is to create a site where ANY query could be entered so the database could be manipulated. My question is as follows:

When I try to type an Insert query, i.e. insert into database_name set Name = "John Doe"; I get an error. I used a control standard to print out what I get and I usually get something in this way

insert into database_name set Name = \"John Doe\";

Other queries such as select work fine with this text field.
Thanks to anyone who can answer this question.

[Anon]

Your insert into statement is incorrect - you're using UPDATE syntax.

You want:

INSERT INTO table_name(field1,field2,etc) VALUES ('value1','value2','etc')

Mark