Posted by Mark D. Smith on 04/21/06 21:48

"Rich" <rich@newsguy.com> wrote in message
news:e2b2eg02ueb@drn.newsguy.com...
> On Fri, 21 Apr 2006 17:17:25 +0100, Mark D. Smith wrote...
<snip>
>
>
> The syntax for an UPDATE is a bit different than an INSERT. It should look
> closer to this, replacing "......" with the rest of the updates
>
> UPDATE job_adverts SET
> ID = '$ID',
> Posted_ID = '$Posted_ID',
> Date_Posted = '$Date_Posted',
> ......
> views = '$views'
> WHERE ID = '$ID';
>
>
> Rich
>
>
> --
> NewsGuy.Com 30Gb $9.95 Carry Forward and On Demand Bandwidth
>

Thanks Rich that's fixed it up nicely.

Mark

• Next in forum: Re: Learning php Sql
• Prev in forum: Re: mysql UPDATE syntax
• Thread view: Re: mysql UPDATE syntax

[Reply to this message]