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

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.