cheese

[Anon]

Hi everyone,

I have an existing database with two tables - one is called "teams" and the other is called "contacts". They each contain a field called "emailaddress" which is the identifying link between the two tables.

On my webpage, I have a 'profile' section where users can update their email address. I have two mysql updates - one to update the "contacts" table and another to update the "teams" table:

$sql = "UPDATE contacts
SET emailaddress = '$emailaddress' " . "WHERE emailaddress = \"$old_emailaddress\"";

$sql2 = "UPDATE teams
SET emailaddress = '$emailaddress' " . "WHERE emailaddress = \"$old_emailaddress\"";

My problem is that only the 1sr update is working - and if i switch the table names, it will update the 2nd table, but only the first $sql command executes - any ideas?

Thanks!

[Anon]

I have no idea as to why. But here is a suggestion.

Why not have one only one table with emailaddresses. Each emailaddress would have a unique numeric id. The teams and the contacts table would then use the emailaddress id as the link. Then when updating an emailaddress, you would only have to make an update to one table. Also you minimize the risk of your teams and contacts tables getting out of sync.

[thefury]

Well im not sure why you’re doing it that way. But the correct syntax is as follows

$sql = "UPDATE contacts SET emailaddress = '$emailaddress' WHERE emailaddress = '$old_emailaddress'";

$sql2 = "UPDATE teams SET emailaddress = '$emailaddress' WHERE emailaddress = ‘$old_emailaddress’";

headers and sql are very very pickey

[Anon]

thanks folks - it appears i simply had some incorrect syntax.

-broseed