1 {{ upvoteCount | shortNum }}
1 {{ upvoteCount | shortNum }}

INSERT INTO mysql

by solidsoul
1 replies
Getting this error
"Couldn't Add Note Please See AdminYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') VALUES ('April 3, 2012','','Hello I really Hope I get this to work soon','') W' at line 1"

using this code

PHP Code:
if (isset($_POST['submit'])) {
$message = $_POST['message'];
$date = date("F j, Y");
$id = $_GET['id'];
 
$insert = mysql_query("INSERT INTO `jeffdesj`.`notes` (date,user,message,,) VALUES ('$date','$user','$message','') WHERE client_id=$id") or die ("Couldn't Add Note Please See Admin" . mysql_error());

 if ($insert) {
 echo "<div align='center'><font color='red'>Note Added Successfully Please Refresh</font></div>";
 }
} 
I dunno what I'm missing?? I'm using _GET cause I have appending the id in the link..
#insert #mysql
  • Profile picture of the author xrampage16
    $insert = mysql_query("INSERT INTO `jeffdesj`.`notes` (date,user,message,,) VALUES ('$date','$user','$message','') WHERE client_id=$id") or die ("Couldn't Add Note Please See Admin" . mysql_error());

    you you don't have to surround     `jeffdesj` with "`". Also, you have two ",,", where you might not need that. If you are inserting a complete row, you might want to try this instead

    Also, insert statements don't have "where" clauses. You just insert and it appends it to the last row.

    $insert = mysql_query("INSERT INTO jeffdesj.`notes` VALUES ('$date','$user','$message','')");

    And see if that works.
    {{ DiscussionBoard.errors[5967786].message }}

Trending Topics