Re: Inexplicable PHP/MySQL behaviour

Aaron, Try this: if($row["home_score"] == 255) == is test for equality = is used for assignment of value Hope it solves the problem - Miles PS We've all been bitten by it. At 09:40 PM 8/9/01 -0400, Aaron Vegh wrote:

Hi there! Say I have a MySQL table like this:

Away_Team     Score     Home_Team         Score       spread
Atlanta            255        San Francisco        255         2

The team names are loaded into the table before my application starts, and all scores are given a default value of 255. One one page, I am able to update the spread (in this case, giving it a value of 2). Here's where the problem happens. On the page where I want to enter the scores (the game results), I want each row of that week's schedule to be a database entry form, _IF_ no score has been entered before. That is done using a code fragment like this: If ($row["home_score"] = 255)

    run code to output a db entry form

But what happens is, the code ignores the value of 255 and instead prints out my "else..." code (which simply outputs the done row with no db entry). And the funny thing is, IF I DON'T UPDATE THE SPREAD ON THE FIRST PAGE, THEN THE GIVEN ROW WILL WORK PERFECTLY ON THE RESULTS PAGE. To summarize: 1. If I don't add a spread to the record on the first page, then the results page works perfectly. 2. If I do add a spread to the record on the first page, then the code thinks that the $home_score != 255, when in fact it still does. The only theory I have is that somehow, PHP is getting the wrong value for the score after the db record has been updated. But I don't understand why! Any insight anyone can provide would be much appreciated. Please, if you can, reply directly to my email address as well as this list. Thanks, Aaron. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net