Problem with mySQL "update" query. - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Problem with mySQL "update" query.

NeakNeak Posts: 87Member
Well. This is the second time I'm posting this... For some reason when I looked at the board today my post wasn't there. This has happened twice before also... I don't know why.

Anyway, on to the question! I have been having trouble with the mySQL query "UPDATE." I am getting an error if I have it give me a die() message. Here is the query:[code]mysql_query("UPDATE news SET title = '$title', name = '$name', date = '$date', content = '$content' WHERE title = '$get_title'");[/code]The connection is fine because in the same file, but a different loop, this query works:[code]$rows = mysql_query("SELECT * FROM news WHERE title = '$get_title'");[/code]
Am I getting something wrong with the syntax of the "UPDATE" query? I've looked on various sites about this and found nothing. Thanks for the help, baby.

Comments

  • DarQDarQ Posts: 1,625Member
    make sure there are NO ' characters in $content or $title etc. i don't see any syntax error either. doesnt mysql give you an error message?

    : Well. This is the second time I'm posting this... For some reason when

    I looked at the board today my post wasn't there. This has happened twice before also... I don't know why.
    :
    : Anyway, on to the question! I have been having trouble with the mySQL query "UPDATE." I am getting an error if I have it give me a die() message. Here is the query:[code]mysql_query("UPDATE news SET title = '$title', name = '$name', date = '$date', content = '$content' WHERE title = '$get_title'");[/code]The connection is fine because in the same file, but a different loop, this query works:[code]$rows = mysql_query("SELECT * FROM news WHERE title = '$get_title'");[/code]
    : Am I getting something wrong with the syntax of the "UPDATE" query? I've looked on various sites about this and found nothing. Thanks for the help, baby.
    :


    [size=5][italic][blue]Dar[RED]Q[/RED][/blue][/italic][/size]
    Jou my no rap dy lekkere dikke tsjap

  • NeakNeak Posts: 87Member
    : make sure there are NO ' characters in $content or $title etc. i don't see any syntax error either. doesnt mysql give you an error message?
    :
    My god! You're right! The only entry to the database that I've tested it with has the title field as "Attack of the X's" -_- How can I fix it so that there can be 's in the title field? I know there's a function for unescaping things, but is there a function to escape all apostrophes in a string?
  • DarQDarQ Posts: 1,625Member
    http://www.php.net/addslashes
    http://www.php.net/stripslashes

    but in some cases it can be very, very tricky when you have single and double qoutes.


    : : make sure there are NO ' characters in $content or $title etc. i don't see any syntax error either. doesnt mysql give you an error message?
    : :
    : My god! You're right! The only entry to the database that I've tested it with has the title field as "Attack of the X's" -_- How can I fix it so that there can be 's in the title field? I know there's a function for unescaping things, but is there a function to escape all apostrophes in a string?
    :

    [size=5][italic][blue]Dar[RED]Q[/RED][/blue][/italic][/size]
    Jou my no rap dy lekkere dikke tsjap

  • NeakNeak Posts: 87Member
    : http://www.php.net/addslashes
    : http://www.php.net/stripslashes

    Thanks...

    : but in some cases it can be very, very tricky when you have single and double qoutes.

    Man. I don't like tricky. ;_;
Sign In or Register to comment.