Wednesday, 15 August 2012

php - why am i getting this query failed syntax error -



php - why am i getting this query failed syntax error -

this question has reply here:

when utilize single quotes, double quotes, , backticks? 8 answers

i can not find out why not working..... maintain getting message

query failed: have error in sql syntax; check manual corresponds mysql server version right syntax utilize near ''laketaho_benny'.'tblpictures' set 'caption' = 'uuuuuuuuuupppp' 'tblpic' @ line 1

and code

$sql = "update `laketaho_benny`.`tblpictures` set `caption` = `$caption` `tblpictures`.`pictureid` =$pictureid;";

single quotes strings. you're thinking of backquotes ( ` ).

php sql

No comments:

Post a Comment