PHP error in script

Discussion in 'PHP' started by espmartin, Jul 31, 2007.

  1. #1
    What's wrong with this code:
    case "new":
    if ($_GET['task'] == "process") {
    $date = date("F jS, Y");
    $sql = "INSERT INTO announcements (title,date,content,group_id) VALUES ('$_POST[title]','$date','$_POST[content]','$_POST[group]');
    if (mysql_query($sql)) {
    displayAlertMessage("green","Announcement Successfully Created");
    }
    else {
    displayAlertMessage("red","A problem occured while creating the announcement, please try again.");
    }
    }
    else {
    include_once('include/something.inc');
    }
    break;
    PHP:
    It keeps giving this error:

     
    espmartin, Jul 31, 2007 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    You're missing a ".

    
    case "new":
    if ($_GET['task'] == "process") {
    $date = date("F jS, Y");
    $sql = "INSERT INTO announcements (title,date,content,group_id) VALUES ('$_POST[title]','$date','$_POST[content]','$_POST[group]')";
    if (mysql_query($sql)) {
    displayAlertMessage("green","Announcement Successfully Created");
    }
    else {
    displayAlertMessage("red","A problem occured while creating the announcement, please try again.");
    }
    }
    else {
    include_once('include/something.inc');
    }
    break; 
    
    PHP:
     
    jestep, Jul 31, 2007 IP
  3. espmartin

    espmartin Well-Known Member

    Messages:
    1,137
    Likes Received:
    46
    Best Answers:
    0
    Trophy Points:
    160
    #3
    Where????? Thanks in advance!!!!
     
    espmartin, Jul 31, 2007 IP
  4. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #4
    It was at the end of the "INSERT INTO announc.... statement.

    I added it in the code that I posted.

    
    //this was the bad code
    $sql = "INSERT INTO announcements (title,date,content,group_id) VALUES ('$_POST[title]','$date','$_POST[content]','$_POST[group]');
    
    //should have been 
    $sql = "INSERT INTO announcements (title,date,content,group_id) VALUES ('$_POST[title]','$date','$_POST[content]','$_POST[group]')";
    
    
    PHP:
     
    jestep, Jul 31, 2007 IP
  5. espmartin

    espmartin Well-Known Member

    Messages:
    1,137
    Likes Received:
    46
    Best Answers:
    0
    Trophy Points:
    160
    #5
    Fount it! Thanks!!!!
     
    espmartin, Jul 31, 2007 IP
  6. nagasharmi

    nagasharmi Peon

    Messages:
    28
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    give ' ".$_post['value']." ' inside of mysql

    then only it give take string value otherwise it will integer .
     
    nagasharmi, Aug 2, 2007 IP