t;.$fname."%'
> and IE.Rank = '$rank'
> and TD.Tenure_Status like '$tenure'
> order by FP.FirstName;
>
> -Original Message-
> From: Jordan Morgan [mailto:[EMAIL PROTECTED]
> Sent: Sunday, September 14, 2003 4:28 PM
> To: David Sears
> S
ch
> info in the mysql docs.
>
> -Original Message-
> From: Jordan Morgan [mailto:[EMAIL PROTECTED]
> Sent: Sunday, September 14, 2003 2:45 PM
> To: David Sears
> Cc: [EMAIL PROTECTED]
> Subject: Re: Newbies asking help with LEFT JOIN
>
> I tried the parenthese
nday, September 14, 2003 12:56 PM
> To: David Sears
> Cc: [EMAIL PROTECTED]
> Subject: Re: Newbies asking help with LEFT JOIN
>
> Thanks for the prompt response David. However, it still doesn't work.
>
> The search page is here:
> http://www.jordymaeproductions.com/P
PM
> To: David Sears
> Cc: [EMAIL PROTECTED]
> Subject: Re: Newbies asking help with LEFT JOIN
>
> Thanks for the prompt response David. However, it still doesn't work.
>
> The search page is here:
> http://www.jordymaeproductions.com/PHP/latest/SearchFaculty.php4
>
> I
That's parentheses () around the inner join, not braces {}.
-Original Message-
From: Jordan Morgan [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 14, 2003 12:56 PM
To: David Sears
Cc: [EMAIL PROTECTED]
Subject: Re: Newbies asking help with LEFT JOIN
Thanks for the prompt res
order by FP.FirstName;
>
> -Original Message-
> From: Jordan Morgan [mailto:[EMAIL PROTECTED]
> Sent: Sunday, September 14, 2003 1:29 AM
> To: [EMAIL PROTECTED]
> Subject: Newbies asking help with LEFT JOIN
>
> Hi,
>
> I'm working on a faculty system a
quot;%'
and FP.FirstName like '%".$fname."%'
and IE.Rank = '$rank'
and TD.Tenure_Status like '$tenure'
order by FP.FirstName;
-Original Message-
From: Jordan Morgan [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 14, 2003 1:29 AM
To: [EMAIL P
Hi,
I'm working on a faculty system and currently I'm building a search
which allows users to generate a list of faculty withint a department
based on their first name, last name, rank, and tenure status. I could
do it without the tenure status criteria however I can't get it work if
the tenure st
