urtlking2jo Posted January 27, 2007 Share Posted January 27, 2007 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> Link to comment https://forums.phpfreaks.com/topic/35957-solved-if-statement-is-not-evaluating-correctly/ Share on other sites More sharing options...
Orio Posted January 27, 2007 Share Posted January 27, 2007 What does this output?[code]$day = $purchase_day[2];echo $day . ""; //debug purpose only[/code]Orio. Link to comment https://forums.phpfreaks.com/topic/35957-solved-if-statement-is-not-evaluating-correctly/#findComment-170532 Share on other sites More sharing options...
emehrkay Posted January 27, 2007 Share Posted January 27, 2007 try triple equal $day === 01 Link to comment https://forums.phpfreaks.com/topic/35957-solved-if-statement-is-not-evaluating-correctly/#findComment-170533 Share on other sites More sharing options...
urtlking2jo Posted January 27, 2007 Author Share Posted January 27, 2007 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. Link to comment https://forums.phpfreaks.com/topic/35957-solved-if-statement-is-not-evaluating-correctly/#findComment-170538 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.