sql insert where statment need help 0.o???

Trying to use the following statement in php using pdo and sqlite
keep getting errors
The separate vars can be echo'd out, so there is no problem with the inputs.
Have no problem doing a simple insert (for new row any column) and select whatever from table column where row = 1
Looks so simple i just can't quite get i right

Hidden Content

You must

[To see links please register here]

or

[To see links please register here]

to view this content.

php code

Hidden Content

You must

[To see links please register here]

or

[To see links please register here]

to view this content.

cheers

:biggrin:

Num5kull

With your SQL INSERT INTO Statement, you've enclosed the id column In single quotes and you haven't ended your SQL query In a semicolon, hence the syntax error near "WHERE".

The value of '100' Is fine (single quotes), but given the id column Is only one word (not separated) you can either enclose It In "Back Ticks", or leave It as Is, but NOT single quotes.

Example:
Column In Back Ticks

Hidden Content

You must

[To see links please register here]

or

[To see links please register here]

to view this content.

No Back Ticks

Hidden Content

You must

[To see links please register here]

or

[To see links please register here]

to view this content.

Either of the two will work. Don't forget to use the semicolon at the end of the statement.