Home > Archive > PHP SQL > May 2005 > query
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Irlan agous 2005-05-09, 3:58 pm |
| $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
| |
| coolsti 2005-05-09, 3:58 pm |
| 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='' ";
| |
| Irlan agous 2005-05-09, 3:58 pm |
| 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='' ";
| |
| coolsti 2005-05-09, 3:58 pm |
| On Mon, 09 May 2005 16:00:06 +0200, Irlan agous wrote:
[color=darkred]
> 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.
|
|
|
|
|