Jump to content

[SOLVED] If Statement is not evaluating correctly


urtlking2jo

Recommended Posts

I store a user-editable date in a mysql DB field.  When the user clicks the "edit" button, I pull all of the information from the correct db record and display it on the page.  My goal is to pre-populate fields they have already entered (so that if they only have one change to make, they don't have to worry about the rest of the page).  I pull the date $purchase_day from the database, and use "explode" to turn it into three components, the day, month and year.  Everything seems to work correctly here, I get 3 separate variables which all appear to be the correct value.  Then I use each of those variables to pre-populate drop down boxes for the month, day and year.  Month and year work fine, but the "day" conditional statement doesn't seem to evaluate correctly. It shows that no day is "selected".  Some of my code is below... it's all the same, I can't figure out why day is acting differently from month and year!  What am I missing?

$sql = "SELECT * FROM tbl_property WHERE login_name = '$fusername' AND item_id = '$item_id'";
$result = mysql_query($sql);
if ($row = mysql_fetch_array($result))
extract($row);

$purchase_day = explode("-", $purchase_day);
$year = $purchase_day[0];
echo $year . "<br>"; //debug purpose only
$month = $purchase_day[1];
echo $month . "<br>"; //debug purpose only
$day = $purchase_day[2];
echo $day . "<br>"; //debug purpose only

<tr>
      <td><span class="style20 style22 style23">Purchase Date: </span></td>
      <td class="style20 style22 style23"><label>
        <select name="month" id="month">
  <option value="00" <?php if ($month == 00) echo "selected"?>>--</option>
          <option value="01" <?php if ($month == 01) echo "selected"?>>JAN</option>
          <option value="02" <?php if ($month == 02) echo "selected"?>>FEB</option>
          <option value="03" <?php if ($month == 03) echo "selected"?>>MAR</option>
          <option value="04" <?php if ($month == 04) echo "selected"?>>APR</option>
          <option value="05" <?php if ($month == 05) echo "selected"?>>MAY</option>
          <option value="06" <?php if ($month == 06) echo "selected"?>>JUN</option>
          <option value="07" <?php if ($month == 07) echo "selected"?>>JUL</option>
          <option value="08" <?php if ($month == 08) echo "selected"?>>AUG</option>
          <option value="09" <?php if ($month == 09) echo "selected"?>>SEP</option>
          <option value="10" <?php if ($month == 10) echo "selected"?>>OCT</option>
          <option value="11" <?php if ($month == 11) echo "selected"?>>NOV</option>
          <option value="12" <?php if ($month == 12) echo "selected"?>>DEC</option>
        </select>
      </label>
        <label>
        <select name="day" id="day">
  <option value="00" <?php if ($day == 00) echo "selected"?>>--</option>
                  <option value="01" <?php if ($day == 01) echo "selected"?>>01</option>
                  <option value="02" <?php if ($day == 02) echo "selected"?>>02</option>
  <option value="03" <?php if ($day == 03) echo "selected"?>>03</option>
  <option value="04" <?php if ($day == 04) echo "selected"?>>04</option>
  <option value="05" <?php if ($day == 05) echo "selected"?>>05</option>
  <option value="06" <?php if ($day == 06) echo "selected"?>>06</option>
  <option value="07" <?php if ($day == 07) echo "selected"?>>07</option>
  <option value="08" <?php if ($day == 08) echo "selected"?>>08</option>
  <option value="09" <?php if ($day == 09) echo "selected"?>>09</option>
  <option value="10" <?php if ($day == 10) echo "selected"?>>10</option>
  <option value="11" <?php if ($day == 11) echo "selected"?>>11</option>
  <option value="12" <?php if ($day == 12) echo "selected"?>>12</option>
  <option value="13" <?php if ($day == 13) echo "selected"?>>13</option>
  <option value="14" <?php if ($day == 14) echo "selected"?>>14</option>
  <option value="15" <?php if ($day == 15) echo "selected"?>>15</option>
  <option value="16" <?php if ($day == 16) echo "selected"?>>16</option>
  <option value="17" <?php if ($day == 17) echo "selected"?>>17</option>
  <option value="18" <?php if ($day == 18) echo "selected"?>>18</option>
  <option value="19" <?php if ($day == 19) echo "selected"?>>19</option>
  <option value="20" <?php if ($day == 20) echo "selected"?>>20</option>
  <option value="21" <?php if ($day == 21) echo "selected"?>>21</option>
  <option value="22" <?php if ($day == 22) echo "selected"?>>22</option>
  <option value="23" <?php if ($day == 23) echo "selected"?>>23</option>
  <option value="24" <?php if ($day == 24) echo "selected"?>>24</option>
  <option value="25" <?php if ($day == 25) echo "selected"?>>25</option>
  <option value="26" <?php if ($day == 26) echo "selected"?>>26</option>
  <option value="27" <?php if ($day == 27) echo "selected"?>>27</option>
  <option value="28" <?php if ($day == 28) echo "selected"?>>28</option>
  <option value="29" <?php if ($day == 29) echo "selected"?>>29</option>
  <option value="30" <?php if ($day == 30) echo "selected"?>>30</option>
  <option value="31" <?php if ($day == 31) echo "selected"?>>31</option>
        </select>
      </label>
        <label>
        <select name="year" id="year">
  <option value="0000" <?php if ($year == 0000) echo "selected"?>>--</option>
                  <option value="2007" <?php if ($year == 2007) echo "selected"?>>2007</option>
                  <option value="2006" <?php if ($year == 2006) echo "selected"?>>2006</option>
  <option value="2005" <?php if ($year == 2005) echo "selected"?>>2005</option>
  <option value="2004" <?php if ($year == 2004) echo "selected"?>>2004</option>
  <option value="2003" <?php if ($year == 2003) echo "selected"?>>2003</option>
  <option value="2002" <?php if ($year == 2002) echo "selected"?>>2002</option>
  <option value="2001" <?php if ($year == 2001) echo "selected"?>>2001</option>
  <option value="2000" <?php if ($year == 2000) echo "selected"?>>2000</option>
        </select>
      </label></td>
    </tr>
    <tr>
I've got it working if I put my day/month/year "number" in quotes and use a triple equal sign.  I still don't really understand why it was evaluating what appeared to be similar variables/statements differently, but it is working anyway.  Thanks for the help.

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.