[SOLVED] SQL syntax?

[galvin]

Maybe this isn't enough info for this question to be answered, but I'll take a shot anyway.  I have the following MySQL query...

 

$query = "INSERT INTO captions (
					cardfile
				) VALUES ('" . $_SESSION['card1'] . "')
				WHERE orderID = " . $_SESSION['orderID'] . " AND card = 1"; 

 

...and every time it runs, I get "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 orderID = X AND card = 1' at line 4"

 

It's pulling in the proper value for orderID (it's always a number, I just put an X above) and card, but it keeps giving this error.  Do I have a problem with an extra (or missing) apostrophe or something?

[jonsjava]

INSERT is for new data. ALTER TABLE changes existing data.  it's used like this:

"ALTER TABLE `captions` SET `table_row`='new_data' WHERE `table_row2` = 'check_against_data' AND `card`=1";

[revraz]

echo $query and check it.  Failing since you use a WHERE with INSERT

[revraz]

I think you mean UPDATE and not ALTER TABLE.

 

INSERT is for new data. ALTER TABLE changes existing data.  it's used like this:

"ALTER TABLE `captions` SET `table_row`='new_data' WHERE `table_row2` = 'check_against_data' AND `card`=1";

[galvin]

Jonsjava, I was incorrectly using INSERT, like you said, so thank you. And revraz, all I needed was UPDATE, like you said.  That did the trick just fine for my purposes.  Thanks to both of you!!!

[jonsjava]

I think you mean UPDATE and not ALTER TABLE.

 

INSERT is for new data. ALTER TABLE changes existing data.  it's used like this:

"ALTER TABLE `captions` SET `table_row`='new_data' WHERE `table_row2` = 'check_against_data' AND `card`=1";

way too tired. just woke up when I posted that.