|
|
Posted by Joshua Ruppert on 12/09/82 11:55
ZafT wrote:
> Well, I'm back...
>
> I have the script working on other update pages, and the only difference is
> the $show variable. It is currently a smallint (I have tried changing to
> varchar and int with no luck). The id field is an int, and the syntax '$id'
> works on a sister script (but that script does not have the '$show'
> variable. I have tried the mysql_real_escape_string() bit proposed by Rik,
> but to no avail. The result is an error like:
>
> You have an error in your SQL syntax; check the manual that corresponds to
> your MySQL server version for the right syntax to use near 'show=1 WHERE
> id='3'' at line 3
>
> Any more thoughts? This is killing me. It has to be something completely
> rediculous.
>
> Shane
It's the double single quotes after the 3 in id='3'' that is causing
that error message. Are you running the $id variable through the
mysql_real_escape_string() function? You only need that for
sring/varchar data.
Navigation:
[Reply to this message]
|