| Re: Help required with UPDATE columns [message #179554 is a reply to message #179540] |
Wed, 07 November 2012 11:07   |
|
|
Originally posted by: Dynamo
On Tue, 06 Nov 2012 13:44:27 +0100, Shake <QUITAESTO(at)QUITAESTO(dot)NOES>
wrote:
> El 06/11/2012 13:40, Dynamo escribió:
>> $query1 = ("UPDATE mytable SET drawing = 'mydrawing.pdf' WHERE id=2");
> [...]
>> $query1 = ("UPDATE mytable SET drawing = $drawing WHERE id=2");
>
> -------------------------------------------^
>
> There are no quotes.
>
> Incorrect:
> - $query1 = ("UPDATE mytable SET drawing = $drawing WHERE id=2");
> correct:
> - $query1 = ("UPDATE mytable SET drawing = '$drawing' WHERE id=2");
>
>
> That's not a PHP problem. Is a SQL one.
>
> Regards.
Thanks Shake. That worked. Will digest other comments in the post
later.
Regards
Dynamo
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]