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:

mysql_query("UPDATE news SET title = '$title', name = '$name', date = '$date', content = '$content' WHERE title = '$get_title'");

The connection is fine because in the same file, but a different loop, this query works:

$rows = mysql_query("SELECT * FROM news WHERE title = '$get_title'");

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.

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:

mysql_query("UPDATE news SET title = '$title', name = '$name', date = '$date', content = '$content' WHERE title = '$get_title'");

The connection is fine because in the same file, but a different loop, this query works:

$rows = mysql_query("SELECT * FROM news WHERE title = '$get_title'");

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


DarQ
Jou my no rap dy lekkere dikke tsjap

: 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?

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?
:

DarQ
Jou my no rap dy lekkere dikke tsjap

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