Update syntax

[han_u_man]

Hi

Please excuse if repeat question.

Is it possible using dreamweavers 'Update Recordset' server behaviour to
access the mysql syntax, in particular SET.

eg: UPDATE persondata SET age=age+1

I'm trying to add or subtract a form entered value to the existing value in
the database record.

Using php, mysql

Ta
Jim

[Alexandro Colorado]

You should use the SET from the php, if you are using phpmyadmin, there is
an option to convert your Query to a PHP code.

If you dont have phpmyadmin, then you can do it by putting the SQL
statement on a function or variable and calling it on an event (clicking a
link).

On Thu, 3 Mar 2005 03:36:39 +0000 (UTC), han_u_man
<webforumsuser@macromedia.com> wrote:

> Hi
>
> Please excuse if repeat question.
>
> Is it possible using dreamweavers 'Update Recordset' server behaviour to
> access the mysql syntax, in particular SET.
>
> eg: UPDATE persondata SET age=age+1
>
> I'm trying to add or subtract a form entered value to the existing
> value in
> the database record.
>
> Using php, mysql
>
> Ta
> Jim
>

--
Alexandro Colorado
------------------------------
Support Engineer
InterAKT Online
[url]http://www.interaktonline.com[/url]
Tel: 40(21) 312.5312