SQL problem in PHP code

Anon

I am making a variable $SQL to be processed by mysql_db_query()

The variables below are defined by a form that executes the following...
Whenever I use:

$SQL = " UPDATE carticles SET";
$SQL = $SQL . " title = '$title', ";
$SQL = $SQL . " author = '$author', ";
$SQL = $SQL . " content = '$content', ";
$SQL = $SQL . " siteurl = '$siteurl', ";
    $SQL = $SQL . " artid = $artid, ";
$SQL = $SQL . " WHERE id = $id ";

$artid is a number and so is $id....
Whenever I process the form I get the following ERROR:

ERROR: You have an error in your SQL syntax near 'artid = '452001' WHERE id = 2 ' at line 1

What is the problem with the $SQL definition?

Anon

did you re-type or cut and copy your code to the forum? I'm wondering about this line specifically:

$SQL = $SQL . " artid = $artid, ";

if you had this:
$SQL = $SQL . " artid = '$artid', ";
[note the single quotes]

it would cause the error you are seeing. Alternatively, you may have typed it correctly and the DB is expecting a string instead of a number, hence you would need the single quotes.

Anon

Thanks that fixed that error. I took out the quotes. Now I still have the error below 🙂
What would be the problem...

Original code:
$SQL = " UPDATE carticles SET";
$SQL = $SQL . " title = '$title', ";
$SQL = $SQL . " author = '$author', ";
$SQL = $SQL . " content = '$content', ";
$SQL = $SQL . " siteurl = '$siteurl', ";
$SQL = $SQL . " artid = $artid, ";
$SQL = $SQL . " WHERE id = $id ";

ERROR: You have an error in your SQL syntax near 'WHERE id = 2 ' at line 1 UPDATE carticles SET title = 'Jon Does Adventures.', author = 'Jon Doe', content = 'One day I was writing fictionless content.', site url = 'http://www.mysites.com', artid = 452001, WHERE id = 2

Anon

you have a space between 'site' and 'url' and you also have a comma after the 'artid = 452001' which you don't need. the comma is causing the current error. the space will simply cause you to not get the value inserted.

Anon

Thank you VERY much for the help. This solved the problem. 🙂

Anon

Gray :
I think your problem occured on the php syntax .
$SQL = $SQL . " title = "$title", ";
and the following as the same with the above
try please
chinese boy

Anon

Gray :
perphese you are a student and i know the syntax is not very similar to you
eg :
$AA=""
echo "the sentence is $AA";
echo "the sentence is '$AA'";
the output is

the sentence is ;
the sentence is $AA
that is the result!
bill zhou

Anon

One question I do have is in the variable $content I established, it would contain an article. Now I do know how to limit a variable using substr($variable, 1, 300). But how do you limit words not just characters? Is there a way to do this?