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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
