[RESOLVED] Best way to deal with a 0-0 tie

fishy

I am wondering how I should deal with a 0 - 0 tie in my athletic scores program. I was using

	 $win = 0;
				 $lose = 0;
				 $tie = 0;
				 while($row = mysql_fetch_array($Resultd)){
				 if ($row['Our_Score'] > $row['Op_Score'] ) 
				 {
				 $win++;
				 }
				  if ($row['Our_Score'] < $row['Op_Score'] ) 
				 {
				 $lose++;
				 }

			 if ($row['Our_Score'] ==  $row['Op_Score'] ) 
			 {
			 $tie++;
			 }

But what happens is that scores that are not put in will show up as ties. So I can remove entries that are 0-0 but some sports actually have 0-0 ties. So I am kinda confused on the best way to code this. I was thinking of adding a check box for 0-0 ties.

Anybody have some ideas on this?

Thanks

tom

fishy

okay so to clarify a bit

I am using is_null() to check if if scores are entered which works if there are no scores but when I try to edit the scores by using a multi input form it enters 0's into the database making every future event a tie. I am currently trying to find a way to keep the form from submitting 0's

tom

	 if( is_null($row['Our_Score']) == true)
				{print "TBD </td></tr>";}
				else {
				 if($row['Our_Score'] > $row['Op_Score'])
				 	{print "<b>W</b> ";}
				else if($row['Our_Score'] < $row['Op_Score'])
					{print "L ";}
				elseif ($row['Our_Score'] == $row['Op_Score']) 
					print "<b>T</b> ";
					print "{$row['Our_Score']} - {$row['Op_Score']}

fishy

Okay,

Forgot to set the default value of the database column as null. That solved my problem

redrabbit

fishy wrote:
Okay,

Forgot to set the default value of the database column as null. That solved my problem

Glad we could help! 🙂

fishy

Its funny that actually just writing out a post helps me.

It takes me a while to figure out what I am actually searching php builder for. I really need to be searching for setting up nulls not working with scores. When I did that I found posts that helped.

There are so many posts on doing similar things with php the tricky part is just finding the right word or phase to search with when you don't actually know what you are searching for.

🙂

thanks

jon3k

I've probably tried to create about 20 posts, and half way through typing out the problem, I figure out how to solve it. Used to happen to me all the time at work ...

Me: "So I've got this problem, I need to figure out how to rewrite this function because there's a huge memory spike when I run it OH probably because I'm not passing the arugments by reference!! Thanks man!"

Co-Worker: blank stare "Uh, no problem."

😃

Weedpacket

fishy wrote:
Its funny that actually just writing out a post helps me.

Not so funny as all that: the act of creating a post that's clear enough to be understood by strangers and contains enough information for them to be able to help, goes towards clarifying the problem for you as well; and the thinking you do while putting the post together also counts as thinking you're doing about the problem itself.

This is why it is so important to ask smart questions in the first place, and not just belt out semiliterate drivel about "why doesnt ti work"!