oh.... thanks! I guess that's why I'm a newbie.
Diana Soares wrote:
> Look at:
>
> if ($tenureid=3)
>
> You're not comparing $tenureid with 3, you're assigning 3 to
> $ternureid... If you want to compare both values, you must use the
> operator "==" (and not only "=").
>
> On Fri, 2003-10-10 at 05:43, Jordan Morgan wrote:
> > 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
> >
> >
> >
> >
> --
> Diana Soares
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
Jordan Morgan
Information Analyst - GeorgiaFIRST HRMS Project
Board of Regents
Office of Information and Instructional Technology
1865 West Broad Street, Athens, GA 30606-3539
Phone: (706) 369-6232
Fax: (706) 369-6429
mailto:[EMAIL PROTECTED] http://www.usg.edu
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
