query

$query = "update reactie,form set 'reactie.persemail' = 'form.email' where
'reactie.persid' = 'form.id'  AND reactie.persemail='' ";

How can i get this query to work?

Irlan

On Mon, 09 May 2005 15:01:34 +0200, Irlan agous wrote:

> $query = "update reactie,form set 'reactie.persemail' = 'form.email' where
> 'reactie.persid' = 'form.id'  AND reactie.persemail='' ";
>
> How can i get this query to work?
>
> Irlan

$query = "update reactie,form set reactie.persemail = form.email where
reactie.persid = form.id  AND reactie.persemail='' ";

Thanks but it doesnt work,

when i try this:

$query = "update reactie,form set reactie.persemail = form.email where
reactie.persid = form.id  AND reactie.persemail='' ";

$query_result= mysql_query($query) or die ("can not change the data");

It gives me cant change the data
"sti" <coo@nospam.com> schreef in bericht
news:pan.2005.05.09.13.13.30.482038@nospam.com...
> On Mon, 09 May 2005 15:01:34 +0200, Irlan agous wrote:
> 
>
> $query = "update reactie,form set reactie.persemail = form.email where
> reactie.persid = form.id  AND reactie.persemail='' ";

On Mon, 09 May 2005 16:00:06 +0200, Irlan agous wrote:

> Thanks but it doesnt work,
>
> when i try this:
>
> $query = "update reactie,form set reactie.persemail = form.email where
> reactie.persid = form.id  AND reactie.persemail='' ";
>
> $query_result= mysql_query($query) or die ("can not change the data");
>
> It gives me cant change the data
> "sti" <coo@nospam.com> schreef in bericht
> news:pan.2005.05.09.13.13.30.482038@nospam.com... 

Then maybe until you get things working you should remove your "or die"
clause and allow mysql to report the actual error message to your screen.
Then you can begin to debug what is wrong.

Note that I didn't check to see if my suggested syntax was correct when
you are trying to do an update with two tables in the update clause. Also
note that this is only allowed for newer versions of mysql. If you have an
older version it might not allow this.