Posted by Joshua Ruppert on 12/17/69 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

LOL I read the error message wrong. ZafT has it right.

[Back to original message]