daily pastebin goal
47%
SHARE
TWEET

Untitled

a guest Sep 14th, 2018 54 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. MySQL syntax error for INSERT
  2. printf("%sn",query);
  3.  
  4. if (mysql_query(conn,query)){
  5.     fprintf(stderr, "%sn", mysql_error(conn));
  6. }
  7.    
  8. INSERT INTO comment (unum,cat_subject,cat_major,cat_minor,unmod)
  9.  VALUES (1,1,1,0,'The cat was lazy.')
  10.  
  11. You have an error in your SQL syntax;
  12.  check the manual that corresponds to your MySQL server version
  13.  for the right syntax to use near ','The cat was lazy.')' at line 1
  14.    
  15. $STH=$DBH->prepare("INSERT INTO comment (unum,cat_subject,cat_major,cat_minor,unmod) VALUES (:u,:s,:ma,:mi,:t)");
  16.    
  17. char* c;
  18. for (c=query; *c; c++) printf("%02x",*c);
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top