Jump to content

Dropdown has value prior to IF statement, another value within IF


PCurry

Recommended Posts

I have 2 dropdowns, both default to 'select'.  The query seemed to work ok before I added validation that both dropdowns need to have a value other than 'select' before the query will be run (i.e., "please select a value for both dropdowns").

 

For one of the dropdowns, the value just prior to that evaluation has a value/year selected, but within that IF evaluation it echos as 'select'.

 

--right before IF--year:2010 post year:2010 year end:2011 owner:C WAGNER

------while in IF--year:select post year:2010 year end:2011 owner:C WAGNER

 

the code is up at brewhas.org/team_history.php

 

any ideas as to why that value seems to change within the IF?

 

<?php
	$url_owner = $_GET['owner'];
	$url_year = $_GET['year'];
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Brewhas Keeper League Fantasy Baseball - Team Transaction History</title>
<link rel="stylesheet" type="text/css" href="style/bklstyle.css" />
<link rel="stylesheet" type="text/css" href="style/mm_travel2.css" />
<link rel="shortcut icon" href="http://www.brewhas.org/images/favicon.ico">
</head>

<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#003300">
    <td rowspan="2" nowrap="nowrap" bgcolor="#003300"> </td>
	<td width="59" rowspan="2" nowrap="nowrap" bgcolor="#003300"><img src="http://www.brewhas.org/images/BKL.jpg" alt="BKLLogo" width="59" height="66"/></td>
    	<td width="608" height="49" align="center" valign="bottom" nowrap="nowrap" bgcolor="#003300" id="logo"><span class="style1">BREWHAS KEEPER LEAGUE </span></td>
    	<td width="415" align="center" valign="bottom" nowrap="nowrap" bgcolor="#003300" id="logo"> </td>
	<td width="5" rowspan="2" bgcolor="#003300"> </td>
</tr>
<tr bgcolor="#003300">
    	<td height="24" align="center" valign="top" bgcolor="#003300" id="tagline"><span class="style2">fantasy baseball</span></td>
  	    <td height="24" align="center" valign="top" bgcolor="#003300" id="tagline"> </td>
</tr>
  	<tr>
    	<td colspan="6" bgcolor="#003300"><img src="images/mm_spacer.gif" alt="" width="1" height="1" border="0" /></td>
  	</tr>

<tr bgcolor="#CCC999">
 	<td height="15" colspan="5" bgcolor="#CCC999"> 
		<div class="container">	
		<div style="clear: both; display: block; padding-bottom: 2px;"></div>
    			<ul id="topnav">
        			<li><a href="http://www.brewhas.org/index.html">Home</a></li>

        			<li><a href="#">Team Pages</a>
					<span>
						<a href="http://www.brewhas.org/team_pages/boothby.html">Boothby</a> |
						<a href="http://www.brewhas.org/team_pages/bradt.html">Bradt</a> |
						<a href="http://www.brewhas.org/team_pages/jcurry.html">J Curry</a> |
						<a href="http://www.brewhas.org/team_pages/pcurry.html">P Curry</a> |
						<a href="http://www.brewhas.org/team_pages/hurlebaus.html">Hurlebaus</a> |
						<a href="http://www.brewhas.org/team_pages/jankowski.html">Jankowski</a> |
						<a href="http://www.brewhas.org/team_pages/oneil.html">O'Neil</a> |
						<a href="http://www.brewhas.org/team_pages/shimizu.html">Shimizu</a> |
						<a href="http://www.brewhas.org/team_pages/cwagner.html">C Wagner</a> |
						<a href="http://www.brewhas.org/team_pages/jwagner.html">J Wagner</a>						
					</span>        			
				</li>

        			<li><a href="http://www.brewhas.org/rules.html">League Rules</a></li>

				<li><a href="http://www.brewhas.org/payout_picks.html">Payouts & Draft Order</a></li>

        			<li><a href="http://www.brewhas.org/standings/2010_standings.html">Standings</a>
            			<span>
						<a href="http://www.brewhas.org/standings/2010_standings.html">2010</a> |
						<a href="http://www.brewhas.org/standings/2009_standings.html">2009</a> |
						<a href="http://www.brewhas.org/standings/2008_standings.html">2008</a> |
						<a href="http://www.brewhas.org/standings/2007_standings.html">2007</a> |
						<a href="http://www.brewhas.org/standings/2006_standings.html">2006</a> |
						<a href="http://www.brewhas.org/standings/2005_standings.html">2005</a> |
						<a href="http://www.brewhas.org/standings/2004_standings.html">2004</a> |
						<a href="http://www.brewhas.org/standings/2003_standings.html">2003</a> |
						<a href="http://www.brewhas.org/standings/2002_standings.html">2002</a> |
						<a href="http://www.brewhas.org/standings/2001_standings.html">2001</a>            			
					</span>        			
				</li>

        			<li><a href="http://www.brewhas.org/drafts/2011_draft.html">Drafts</a>
            			<span>
						<a href="http://www.brewhas.org/drafts/2011_draft.html">2011</a> |
						<a href="http://www.brewhas.org/drafts/2010_draft.html">2010</a> |
						<a href="http://www.brewhas.org/drafts/2009_draft.html">2009</a> |
						<a href="http://www.brewhas.org/drafts/2008_draft.html">2008</a> |
						<a href="http://www.brewhas.org/drafts/2007_draft.html">2007</a> |
						<a href="http://www.brewhas.org/drafts/2006_draft.html">2006</a> |
						<a href="http://www.brewhas.org/drafts/2005_draft.html">2005</a> |
						<a href="http://www.brewhas.org/drafts/2004_draft.html">2004</a> |
						<a href="http://www.brewhas.org/drafts/2003_draft.html">2003</a> |
						<a href="http://www.brewhas.org/drafts/2002_draft.html">2002</a> |
						<a href="http://www.brewhas.org/drafts/2001_draft.html">2001</a>            			
					</span>        			
				</li>

        			<li><a href="http://www.brewhas.org/excelfiles/alltimeaverages.xls">Records</a></li>
				<li><a href="http://www.brewhas.org/excelfiles/transactions.xls">Transactions</a></li>
    			</ul>
		</div>		
	</td>
</tr>
<tr>
	<td width="164" bgcolor="#FFFFFF"> </td>

	<td width="59" bgcolor="#FFFFFF"> </td>

	<td colspan="4" valign="top" bgcolor="#FFFFFF">
		<table border="0" cellspacing="0" cellpadding="2" width="835">
			<div align="center">
				<tr>
					<td width="831" height="31" class="pageName">
						<div align="left"></div>
					</td>
				</tr>
			</div>
		</table>
	</td>
</tr>
</table>

<div id="header"></div>
<div id="leftcol_long"></div>
<div id="content_long">
<h2>Transaction Search - Team History</h2>

    <table border="0" cellspacing="0" cellpadding="1" width="95%" align=center>
    <tr>
          	<td bgcolor="#ffffff" height="35" valign="top" rowspan="2"> 
         		<form name="form1" method="post" action="http://brewhas.org/team_history.php">
					<table border="0" align=left>
							<tr>
								<td>Year:
									<select name='year'>
										<option value='select'>SELECT</option>
										<option value='2011' <?php if($_POST['year'] == '2011') echo "selected"?>>2011</option>
										<option value='2010' <?php if($_POST['year'] == '2010') echo "selected"?>>2010</option>
										<option value='2009' <?php if($_POST['year'] == '2009') echo "selected"?>>2009</option>
										<option value='2008' <?php if($_POST['year'] == '2008') echo "selected"?>>2008</option>
										<option value='2007' <?php if($_POST['year'] == '2007') echo "selected"?>>2007</option>
										<option value='2006' <?php if($_POST['year'] == '2006') echo "selected"?>>2006</option>
										<option value='2005' <?php if($_POST['year'] == '2005') echo "selected"?>>2005</option>
										<option value='2004' <?php if($_POST['year'] == '2004') echo "selected"?>>2004</option>
										<option value='2003' <?php if($_POST['year'] == '2003') echo "selected"?>>2003</option>
										<option value='2002' <?php if($_POST['year'] == '2002') echo "selected"?>>2002</option>
										<option value='2001' <?php if($_POST['year'] == '2001') echo "selected"?>>2001</option>
									</select>
									Owner:
									<select name='owner'>
										<option value='select'>SELECT</option>
										<option value='J BOOTHBY'<?php if($_POST['owner'] == 'J BOOTHBY') echo "selected"?>>J BOOTHBY</option>
										<option value='K BRADT' <?php if($_POST['owner'] == 'K BRADT') echo "selected"?>>K BRADT</option>
										<option value='J CURRY' <?php if($_POST['owner'] == 'J CURRY') echo "selected"?>>J CURRY</option>
										<option value='P CURRY' <?php if($_POST['owner'] == 'P CURRY') echo "selected"?>>P CURRY</option>
										<option value='R HURLEBAUS' <?php if($_POST['owner'] == 'R HURLEBAUS') echo "selected"?>>R HURLEBAUS</option>
										<option value='M JANKOWSKI' <?php if($_POST['owner'] == 'M JANKOWSKI') echo "selected"?>>M JANKOWSKI</option>
										<option value='T ONEIL' <?php if($_POST['owner'] == 'T ONEIL') echo "selected"?>>T ONEIL</option>
										<option value='C WAGNER' <?php if($_POST['owner'] == 'C WAGNER') echo "selected"?>>C WAGNER</option>
										<option value='J WAGNER' <?php if($_POST['owner'] == 'J WAGNER') echo "selected"?>>J WAGNER</option>
										<option value='J BADER' <?php if($_POST['owner'] == 'J BADER') echo "selected"?>>J BADER</option>
										<option value='M SUH' <?php if($_POST['owner'] == 'M SUH') echo "selected"?>>M SUH</option>
									</select>
								</td>
								<td nowrap class="row1" width="40"><input type="submit" value="Submit" name="submit"></td>
								<td nowrap class="row1" width="60"></td>
								<td><p><img src="images/baseball.jpg" alt="baseball" width="8""height=8"" /><span class="style7"> Note: For the 2001 season, only the draft transactions are available.</span></p></td>
							</tr>
					</table>
			</form>
		</td>
	</tr>
</table>

<?php
	include 'config.php';
	include 'opendb.php';

	//Include the PS_Pagination class
	include('ps_pagination.php');

	if((isset($url_year))&&(isset($url_owner)))
		{		//If a year and owner appear in the URL, meaning we're past page 1  --> get the year and owner from the URL parms
			$year_search = $url_year;
			$owner_search = $url_owner;
		}
	else		//If a year and owner have not been entered and do not appear in the URL	(first time thru) --> get them from the form
		{
			$year_search = $_POST['year'];
			$owner_search = $_POST['owner'];
		}

	switch ($year_search)
		{
			case "2011":
				$year_end="2012";
				break;
			case "2010":
				$year_end="2011";
				break;
			case "2009":
				$year_end="2010";
				break;
			case "2008":
				$year_end="2009";
				break;
			case "2007":
				$year_end="2008";
				break;
			case "2006":
				$year_end="2007";
				break;
			case "2005":
				$year_end="2006";
				break;
			case "2004":
				$year_end="2005";
				break;
			case "2003":
				$year_end="2004";
				break;
			case "2002":
				$year_end="2003";
				break;
			case "2001":
				$year_end="2002";
				break;
		}
		echo "--right before IF--";
		echo "year:".$year_search." ";
		echo "post year:".$_POST['year']." ";
		echo "year end:".$year_end." ";
		echo "owner:".$owner_search." ";

	//This checks to see if both the year and the owner have been selected.
	if(($year_search="select")||($owner_search="select"))
		{
		echo "<BR>"."------while in IF--";
		echo "year:".$year_search." ";
		echo "post year:".$_POST['year']." ";
		echo "year end:".$year_end." ";
		echo "owner:".$owner_search;
			echo "<p class='style7'>Please select both a year and a team owner.</p>";
			exit;	
		}
	else  //sets the query to get the number of rows
		{						
			$sql = "SELECT * FROM `BKL_TRANSACTIONS` WHERE (((TO_OWNER='$owner_search')OR(FROM_OWNER='$owner_search')) and (TRANS_DT >='$year_search') AND (TRANS_DT <='$year_end'))";	
		}	

	$count = mysql_query($sql) or die ("Could not execute the query");   //executes the query to count the number of matching rows
	//Count the number of results 
	$numrows=mysql_num_rows($count);
	echo "<p class='style7'>Your search: "".$year_search." ".$owner_search."" returned <b>".$numrows."</b> results.</p>";

	//Count the number of results 

	/*
	 * Create a PS_Pagination object
	 * 
	 * $conn = MySQL connection object (defined in opendb.php)
	 * $sql = SQl Query to paginate
	 * 50 = Number of rows per page
	 * 5 = Number of links
	 * "year=valu1&owner=value2" = Append name parameters ($year_search and $owner_search) to paginations links
	 */

	$pager = new PS_Pagination($conn, $sql, 50, 5, "year=$year_search&owner=$owner_search");

	/*
	 * The paginate() function returns a mysql result set
	 * or false if no rows are returned by the query
	*/
	$rs = $pager->paginate();  //executes the query		
	if(!$rs) die(mysql_error());

			if ($numrows == 0)  //if no matches, don't display the table 
					exit;
			else				//build the table and insert rows 
				{
							echo "<table border=1 cellspacing=0 cellpadding=1 width='77%' align=left bordercolor=#666666>";
							echo "<tr bgcolor=#cccc99 class='style5'><th width='10%' class='style5'>Date</th>";
							echo "<th width='10%' class='style5'>Action</th>";
							echo "<th width='12%' class='style5'>From</th>";
							echo "<th width='12%' class='style5'>To</th>";
							echo "<th width='5%' class='style5'>Pos</th>";
							echo "<th width='18%' class='style5'>Name</th>";		
							echo "<th width='5%' class='style5'>Round</th></tr>";							

						while ($row = mysql_fetch_array($rs))
						{
							echo "<tr><td width='10%' class='style6'>".$row['TRANS_DT']."</td>";
							echo "<td width='10%' class='style6'>".$row['TRANS_ACTION']."</td>";
							echo "<td width='12%' class='style6'>".$row['FROM_OWNER']."</td>";
							echo "<td  width='12%' class='style6'>".$row['TO_OWNER']."</td>";
							echo "<td  width='5%' class='style6'>".$row['POSITION']."</td>";
							echo "<td  width='18%' class='style6'>".$row['PLAYER_FNAME']." ".$row['PLAYER_LNAME']."</td>";
							echo "<td  width='5%' class='style6'>".$row['DRAFT_RND']."</td></tr>";
						}
							//Display the navigation
							if ($numrows > 50)
								{
								echo "<p class='style7'>".$pager->renderFullNav()."</p>";
								}
							echo "</table>";
				}			
?>
</div>
<div id="rightcol_long"></div>
<div id="footer"><p align="center" class="style8">Brewhas Keeper League  - <img src="images/icon_mlb.gif" alt="mlb" width=36 height=18> -  Established 2001</p></div>
<p></p>
</body>
</html>

Link to comment
Share on other sites

You assigned the value to it:

 

if(($year_search="select")||($owner_search="select"))

 

A single equal-sign "=" is assignment -- It takes two to test "=="

 

if(($year_search=="select")||($owner_search=="select"))

 

(or three "===" for equivalence, meaning same value and same datatype - does not apply here)

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.