Hi,
I have the following statement:
echo "$tenureid<P>";
if ($tenureid=3)
{
// get faculty employment record - award date
$sql = "select TD.Award_Date from TenureDescription TD LEFT JOIN
InstitutionEmployment IE on TD.TenureDescriptionID=IE.Tenure WHERE
IE.FacultyMember='$fid'";
$result = mysql_db_query($database, $sql, $connection) or die ("Error in query: $sql.
" . mysql_error());
// obtain data from resultset
list($tenuredate) = mysql_fetch_row($result);
echo "<B>Date Tenure Granted</B>: ";
echo fixDate($tenuredate);
echo "<P>";
}
else {
echo "<B>Date Tenure Granted</B>: Null<P>";
}
and I can't figure out why I always get the following result:
----------------------------------------------------------------
2
Date Tenure Granted: 31 Dec 1969
---------------------------------------------------------------
or
----------------------------------------------------------------
1
Date Tenure Granted: 31 Dec 1969
---------------------------------------------------------------
when 1) tenureid <> 3, and 2) no 31 Dec 1969 date in the database anywhere.
The only thing I can think of is that I modified the dropdown box for the tenure date
on the data entry page like this:
<tr>
<td>Date Tenure Granted<br><font size="-2">(in mm-dd-yyyy format)</font></td>
<td>
<select name="tmm">
<option value="0" selected='selected'></option>
<? for ($x=1; $x<=12; $x++) { echo "<option value=\"" . sprintf("%02d", $x) . "\">" .
sprintf("%02d", $x) . "</option>"; } ?>
</select> -
<select name="tdd">
<option value="0" selected='selected'></option>
<? for ($x=1; $x<=31; $x++) { echo "<option value=\"" . sprintf("%02d", $x) . "\">" .
sprintf("%02d", $x) . "</option>"; } ?>
</select> -
<select name="tyyyy">
<option value="0" selected='selected'></option>
<!-- display from 1970 to (current year) -->
<? for ($x=(date("Y", mktime())); $x>=1970; $x--) { echo "<option
value=$x>$x</option>"; } ?>
</select>
</td>
</tr>
by adding <option value="0" selected='selected'></option> to those 3 fields as I want
null to be a default selection. but I can't imagine why that'll mess up the if
statement evaluation.
It seems that the 1st if statement just runs whatever the tenureid is.
Can anyone help me on this? I'm using PHP 4.2.2 and MySQL 3.23.54 btw.
Thanks millions!
Jordan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
