FUDforum: comp.lang.php » Help required with UPDATE columns

Home » Imported messages » comp.lang.php » Help required with UPDATE columns

Show: Today's Messages :: Polls :: Message Navigator

Re: Help required with UPDATE columns [message #179540 is a reply to message #179539]

Tue, 06 November 2012 12:44

Shake
Messages: 40
Registered: May 2012

Karma:

Member

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.

Report message to a moderator

[Message index]

		Help required with UPDATE columns By: Anonymous on Tue, 06 November 2012 12:40
		Re: Help required with UPDATE columns By: Shake on Tue, 06 November 2012 12:44
		Re: Help required with UPDATE columns By: Thomas 'PointedEars' on Tue, 06 November 2012 17:59
		Re: Help required with UPDATE columns By: Shake on Tue, 06 November 2012 18:06
		Re: Help required with UPDATE columns By: Thomas 'PointedEars' on Tue, 06 November 2012 18:13
		Re: Help required with UPDATE columns By: Shake on Tue, 06 November 2012 18:20
		Re: Help required with UPDATE columns By: M. Strobel on Tue, 06 November 2012 18:30
		Re: Help required with UPDATE columns By: Shake on Tue, 06 November 2012 18:45
		Re: Help required with UPDATE columns By: Thomas 'PointedEars' on Tue, 06 November 2012 18:57
		Re: Help required with UPDATE columns By: M. Strobel on Tue, 06 November 2012 19:36
		Re: Help required with UPDATE columns By: Thomas 'PointedEars' on Tue, 06 November 2012 18:53
		Re: Help required with UPDATE columns By: Shake on Tue, 06 November 2012 19:36
		Re: Help required with UPDATE columns By: Jerry Stuckle on Tue, 06 November 2012 20:02
		Re: Help required with UPDATE columns By: Anonymous on Wed, 07 November 2012 11:07
		Re: Help required with UPDATE columns By: Jerry Stuckle on Tue, 06 November 2012 13:15
		Re: Help required with UPDATE columns By: Anonymous on Wed, 07 November 2012 11:05
		Re: Help required with UPDATE columns By: Jerry Stuckle on Wed, 07 November 2012 12:07

Previous Topic:	Output status during processing
Next Topic:	How awesome Virtual Sailor 7 is

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 02:32:45 GMT 2024

Total time taken to generate the page: 0.04165 seconds