WHERE something = something... ?

[jc94062]

I've been trying to crack this for hours, and it doesn't seem to like me, I'm trying to update a table, which was gonna be easy, I need to update the field joined so that when someone is accepted they no longer appear on the pending list.

$joinedquery = "UPDATE joining WHERE zonename='$newbieperson' SET joined='Y'";
$joinedresult = mysql_query($joinedquery);
mysql_close();

Now, I think the zonename is the wrong bit, the $newbieperson comes up ok on an echo, but I need to update it where its the same as the variable $zonename...

Desired Zone Name:&nbsp;&nbsp;&nbsp;</td><td><input type="text" name="zonename" size="15" maxlength="30" value="<?php echo $details["zonename"] ?>">

The above also works fine, its stuck in a table and the idea is it can be edited if needed, then submitted (which I think may work if I can solve the updating problem) and then updates the table. If anyone can point out what I've missed I'd be really grateful!

Thanks anyone.

[harlan]

i didnt even read your entire post, but from what i remember, SQL requires that the "SET ..." part of the statement is placed BEFORE the "WHERE ..." segment. try flipping them and see if it works.

ordering makes a big difference. changing the order of your WHERE ... AND ... AND statements can highly change the speed of execution.

[Anon]

$joinedquerry = MYSQL_QUERY("UPDATE joining SET joined = 'Y' WHERE zonename = '$newbieperson'") or die(mysql_error());

there ya go, this should work for ya to change the table. Enjoy!!

-Jason Rottman

[jc94062]

It doesn't work, I have found out a had a few other major errors earlier on that I've sorted but for some reason it still doesn't want to work.

Thanks anyways, I'm sure those errors would have caught me out as well!

[jc94062]

I went through the whole lot and I had so mucn error checking and things it made no sense and variables were mixed up but I finally got it thanks 🙂!

[jc94062]

Okay, now been doing this stupid script all day.
After those problems I thought I had it, but no...

if ($submit) {

if ($xvt == "Y") {insert stuff;}

}

but no! That doesn't work cause I got an if inside an if...

if (($submit) && ($xvt == "Y")) {insert stuff;}

nope, no joy there...

if (($submit) && ($xvt == "Y") && ($xwa == "N") && ($rs == "N") && ($jk == "N")) {insert stuff;}

and no again!

HELP! I started trying to do this at 11:00, its now coming up to 01:00 and I've spent 10 hours + today on this 200 line file that doesn't want to work for me. Sure, I'm a newbie and ain't been near PHP for a few weeks but I shouldn't be missing such obvious things!

Thanks VERY much, I have to go get 5 hours sleep before school.

[Anon]

Hey, why dont you try this:

if ($submit) {
if ($xvt == "Y") {
// Insert Stuff
}
}

If that doesnt work, email me again, and Ill be happy to help you, Im always on. [e-mail]