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.
    Signature

    Developer and Admin for Komputer King LLC hosting - Offering lightning fast web hosting and Quality Backlink Building

    {{ DiscussionBoard.errors[5967786].message }}

Trending Topics