Re: newbie select statement question

2003-10-13 Thread Rory McKinley
) - Original Message - From: Jordan Morgan [EMAIL PROTECTED] To: Nobody [EMAIL PROTECTED] Cc: Diana Soares [EMAIL PROTECTED]; mysql [EMAIL PROTECTED] Sent: Friday, October 10, 2003 2:24 PM Subject: Re: newbie select statement question The date is stored as dates instead of timestamps. Yes

Re: newbie select statement question

2003-10-10 Thread Diana Soares
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 $tenureidP;

Re: newbie select statement question

2003-10-10 Thread Nobody
[EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Friday, October 10, 2003 8:58 AM Subject: Re: newbie select statement question 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

Re: newbie select statement question

2003-10-10 Thread Jordan Morgan
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

Re: newbie select statement question

2003-10-10 Thread Jordan Morgan
Soares [EMAIL PROTECTED] To: Jordan Morgan [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Friday, October 10, 2003 8:58 AM Subject: Re: newbie select statement question Look at: if ($tenureid=3) You're not comparing $tenureid with 3, you're assigning 3 to $ternureid... If you

newbie select statement question

2003-10-09 Thread Jordan Morgan
Hi, I have the following statement: echo $tenureidP; 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 =