Update :@

[zingbats]

I have a form that I want to use to update a table.

The form is like this:

Clan_name: |-----------|
Clan_URL : |-----------|

etc, etc.

What would be a very easy process script that the form posted to, to update the table.

and could you do:

$query = "UPDATE clans SET clan_name = '$clan_name' , SET clan_url = '$clan_url' WHERE clan_name = '$clan_name;

Thanks
Alex.

[jpmoriarty]

you dont need to set the clan name to the same thing as it was:

$query = "UPDATE clans SET clan_url = '$clan_url' WHERE clan_name = '$clan_name";

[zingbats]

Yeah... but what if I change the clan_name on the form? That would make it impossible for it to find the records.

[zingbats]

If I do

WHERE clan_name = '$clan_name'

Then it may check for the NEW clan_name that has been entered in the form. Not the old name. This is a problem.