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
: 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
:
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?
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
: 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. ;_;