[SOLVED] Whats wrong with my query?

[mike12255]

I can never fix these/get them right....

 

What is wrong with this one:

 

$sql = "INSERT INTO pages (info) VALUES ('$info') WHERE page = '".$page."' ";

 

it outputs this:

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE page = 'wine'' at line 1

 

i though i had it so that one " didnt actually cant as apart of the query

[adamlacombe]

Try:

$sql = "INSERT INTO pages (info) VALUES ('$info') WHERE page='$page'";

[mike12255]

i've tried that query before and just again, im getting the same error

[adamlacombe]

hmm...

it has something to do with the:

WHERE page='".$page."'

im not sure...

sorry.

[mike12255]

no im talking about the query you posted

[adamlacombe]

yeah I know. It must have something to do with the WHERE part of it. everything else seem to be correct.

[adamlacombe]

try:

$sql = "INSERT INTO pages (info) VALUES ('$info') WHERE page = '{".$page."}' ";

[mike12255]

nope,

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE page = '{wine}'' at line 1

 

 

thanks for the effort though

[adamlacombe]

thanks,

sorry i couldn't help.

im sure someone else can.

hope you get it fixed soon!

 

-Adam

[DavidAM]

Did you escape the strings ($info and $page) before you put them in the $sql statement?

 

Add

echo '|' . $sql . '|';

just before you execute the query.  The vertical bars will help isolate the actual query string.  Post what is there and we'll get a better idea of the problem.  There may be something in one of the variables ($info or $page) that the server is interpreting. 

 

[mike12255]

|INSERT INTO pages (info) VALUES ('

 

testdfasddfasdfsfadsfg

') WHERE page = '{wine}' |

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE page = '{wine}'' at line 1

 

I added a <br> after the last | in your code

[DavidAM]

Sorry, what am I thinking?  INSERT does not allow a WHERE clause.  The record will be ADDED to the database.

 

Are you trying to UPDATE an existing row?

$sql = "UPDATE pages SET info = '" . $info . "' WHERE page = '".$page."' ";

 

or are you trying to INSERT a new row?

$sql = "INSERT INTO pages (info, page) VALUES ('" . $info . "', '" . $page . "');

 

 

[mike12255]

...what am i thinking, i ment update

 

thanks.