Table Joins Question

jennides

Hi,

The following is what I'm currently using...

if ($POST['id'] != $member['id']) {
$query ="UPDATE $MemberTable SET id = '$POST[id]' WHERE id = '$member[id]'";
result = mysql_query("$query");

$query ="UPDATE $IntroTable SET id = '$_POST[id]' WHERE id = '$member[id]'";
$result = mysql_query("$query");

$query ="UPDATE $StatsTable SET id = '$_POST[id]' WHERE id = '$member[id]'";
$result = mysql_query("$query");

$query ="UPDATE $MetaTable SET id = '$_POST[id]' WHERE id = '$member[id]'";
$result = mysql_query("$query");

}

As I'm updating the same field in each table I believe I should be able to do this update all in one query using a JOIN, the only problem is I've read the manual, gone through my 2 books on MySQL and I still can't get it to work.

Can any one offer some advice to a budding php/mysql'er?

Thanks

JeNNiDeS

Lars_Berg

You can only update one table at a time.

Why should you need to store the same data in four different tables?

jennides

Hi Lars,

Thanks for the info. I guess I'll need to leave it as is.

As for your question, what I am doing is updating the common identifier in each table... the ID of the member.

Each table stores different data/preferences for each member. If a member decides to upgrade to full paid member their id is changed, therefore I need to update their ID in all of the tables.

Thanks again.

JeNNiDeS