My problem is I can't seem to find the right place to
put an order by clause in my statement.
I have this select statement:
$query_rsVJ = SELECT Jobs.PostStart,
Jobs.JobID,Jobs.JobTitle,
Jobs.City, Ind.Categories, VendorSignUp.CompanyName,
US.States, Term.Tax FROM Jobs
INNER JOIN Ind ON
Hi Stu
something like
$query_rsVJ = SELECT Jobs.PostStart,
Jobs.JobID,Jobs.JobTitle,
Jobs.City, Ind.Categories, VendorSignUp.CompanyName,
US.States, Term.Tax FROM Jobs
INNER JOIN Ind ON (Jobs.Industry = Ind.CIDs)
INNER JOIN US ON (Jobs.State = US.SID)
INNER JOIN SignUp ON (Jobs.VID = SignUp.VID)
--- Bastien Koert [EMAIL PROTECTED] wrote:
Hi Stu
something like
Bif(!empty($s_Ind)) $aWHERE[] = Jobs.Industry IN
($s_Ind) ;
if(!empty($s_State)) $aWHERE[] = Jobs.State IN
($s_State);
if(!empty($s_TType)) $aWHERE[] = Jobs.Term IN
($s_TType);
if(!empty($JTitle)) $aWHERE[] =