SQL query works when run as query on server, but will not work from PHP code

Question

I'm running this via PHP and well the first query gets run perfectly then right after it I run the second query and it does nothing. Its rows never get updated for some reason, but when I type out the query manually on the sql server, it works perfectly.

Anyone have any idea why its not working in the php code?

$qry = "UPDATE Matches SET winner ='$winner' WHERE TOURN_KEY = '$tournKey'AND MATCH_KEY='$matchKey' ";

$result = @mysql_query($qry);

$qryPoints = "UPDATE members, MemberBets SET members.points = members.points + MemberBets.amountBet + MemberBets.amountBet WHERE members.member_id=MemberBets.member_id and MemberBets.MATCH_KEY ='$matchKey' and MemberBets.TOURN_KEY = '$tournyKey' and MemberBets.player = '$winner'";

$resultPoints = @mysql_query($qryPoints);

Try and print those queries and see if they are what they are supposed to be. — quantumSoup
– quantumSoup, Commented Jul 2, 2010 at 3:58
Could you echo $qryPoints at the end and tell us what it looks like? — deceze
– deceze ♦, Commented Jul 2, 2010 at 3:58
Another thing you could do is print out the error mySQL gives you, ie: $resultPoints = mysql_query($qryPoints) or die(mysql_error()); — quantumSoup
– quantumSoup, Commented Jul 2, 2010 at 4:02
UPDATE members, MemberBets SET members.points = members.points + MemberBets.amountBet + MemberBets.amountBet WHERE members.member_id=MemberBets.member_id and MemberBets.MATCH_KEY ='53' and MemberBets.TOURN_KEY = '' and MemberBets.player = 'player1' holy crap what happen to my $tournKEY value hmm... going to echo the working query and see if its blank too then at least now I know what direction to look in thanks — bob
– bob, Commented Jul 2, 2010 at 4:06

Ian Lesperance · Accepted Answer · 2010-07-02 04:04:47Z

2

You appear to have a typo. You have a $tournKey variable in the first query and a $tournyKey variable in the second. Since you say the first query works, I'm guessing the second variable name is wrong.

answered Jul 2, 2010 at 4:04

Ian Lesperance

5,1591 gold badge30 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

bob Over a year ago

lol i guess this is what i get for trying to code late at night dead tired... I need sleep Thanks so much man would have never spotted that today

Collectives™ on Stack Overflow

SQL query works when run as query on server, but will not work from PHP code

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related