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

Num5kull · 06-02-2017, 12:18 AM

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

Code:
INSERT INTO table  ('stringstore')
VALUES ('string')
WHERE ('id') = ('100')

errorcode :
near "WHERE": syntax error:

php code

Code:
$id = "100";

if(!empty($astring))
 {
    $string = $astring;
    $db = new PDO('sqlite:sqlite.db');
    $result = $db->prepare("INSERT INTO table ('stringstore') VALUES ('$string') WHERE id = ('$id')");
#debuging
if (!$result)
 {
    echo "\nPDO::errorInfo():\n";
    print_r($db->errorInfo());
}
    $result->execute();
    
}

error:
 Call to a member function execute() on boolean

cheers

Num5kull

mothered · 06-02-2017, 06:58 AM

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

Code:
 WHERE (`id`) = ('100') ;

No Back Ticks

Code:
WHERE (id) = ('100') ;

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