Re: newbie select statement question

2003-10-13 Thread Rory McKinley
x27;t" (Unknown) - 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 Subj

Re: newbie select statement question

2003-10-10 Thread Jordan Morgan
nd binary and those who don't" (Unknown) > - Original Message - > From: "Diana Soares" <[EMAIL PROTECTED]> > To: "Jordan Morgan" <[EMAIL PROTECTED]> > Cc: "mysql" <[EMAIL PROTECTED]> > Sent: Friday, October 10, 2003 8:5

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 0

Re: newbie select statement question

2003-10-10 Thread Nobody
ot; <[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 $tenure

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 "$te

newbie select statement question

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